 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / December 2006Columns: I'm seeing yellow bars
I have a file, and after copying and pasting to some columns, I'm seeing these yellow bar on far right in columns I have not used yet. Any ideas appreciated. http://img250.imageshack.us/img250/7959/picture1yr5.png OS 10.4.7 Office 2004 > I have a file, and after copying and pasting to some columns, I'm seeing > these yellow bar on far right in columns I have not used yet. Any ideas [quoted text clipped - 4 lines] > OS 10.4.7 > Office 2004 Looks like you have a yellow "fill colour" selected. Pick those cells, then fill them again with any colour you want (or no colour at all). You will find the fill colour near the font colour in the formatting palate. PhilD -- <>< On 12/18/06 12:29 AM, in article 1166430589.418696.76170@79g2000cws.googlegroups.com, "PhilD" <phildeaves@yahoo.co.uk> wrote: >> I have a file, and after copying and pasting to some columns, I'm seeing >> these yellow bar on far right in columns I have not used yet. Any ideas [quoted text clipped - 15 lines] > -- > <>< Thanks Phil! Appreciate it, as not getting much help here for some reason. I can't select those cells because they go on indefinitely. Column H,I, J, K, L, ETC. and the yellow bar just keeps going on. Also, what the heck is this? I saw it happen before my eyes, but couldn't do anything. All I did was for column D is do a Select all column and then paste (control D) the first cell to all others, then these yellow bars were created in All columns starting in H. But not for all rows, just a handful of rows, like every 30 or 40th row, totally random. It's like the program is on drugs. Kevs OS 10.4.7 Office 2004 > Thanks Phil! > Appreciate it, as not getting much help here for some reason. > I can't select those cells because they go on indefinitely. Column H,I, J, > K, L, ETC. and the yellow bar just keeps going on. You should be able to select the cells. If all else fails, use the arrow keys to get to the first cell (say H1), then shift-command-right arrow to select everything from there to the right hand edge of the sheet (column IV, I believe). Then change the colour. Actually, if this occurs on more than one row, then after shift-command-right arrow press control-space to select every row in the selected columns, THEN change the colour as appropriate. > Also, what the heck is this? I saw it happen before my eyes, but couldn't do > anything. All I did was for column D is do a Select all column and then > paste (control D) the first cell to all others, then these yellow bars were > created in All columns starting in H. But not for all rows, just a handful > of rows, like every 30 or 40th row, totally random. Sounds to me like there was something in whatever you pasted that didn't manifest itself until pasting. Not totally sure, though. PhilD -- <>< On 12/19/06 12:47 AM, in article 1166518076.224067.285250@t46g2000cwa.googlegroups.com, "PhilD" <phildeaves@yahoo.co.uk> wrote: >> Thanks Phil! >> Appreciate it, as not getting much help here for some reason. [quoted text clipped - 23 lines] > -- > <>< Thanks Phil! New news! The yellow bars not only wont fill with new color, they wont even delete either. And if you try to delete the column with bar in it nothing happens. Actually, nothing will type into any columns past column F. Even cells that were not cursed with this bizarre yellow bar. OS 10.4.7 Office 2004 On 12/19/06 12:47 AM, in article 1166518076.224067.285250@t46g2000cwa.googlegroups.com, "PhilD" <phildeaves@yahoo.co.uk> wrote: >> Thanks Phil! >> Appreciate it, as not getting much help here for some reason. [quoted text clipped - 23 lines] > -- > <>< Phil: Ok got it solved!! See thread: "select to infinity" Actually your technique of selection was best: the shift-command-right right arrow did it perfectly. So actually did not understand: " if this occurs on more than one row, then after shift-command-right arrow press control-space to select every row in the selected columns, THEN change the color as appropriate." Don't get that, shift command arrow did the trick, don't understand the control space idea then OS 10.4.7 Office 2004 On 12/19/06 8:49 PM, in article C1AE00E2.1EAEB%studiok4485@hotmail.com, > On 12/19/06 12:47 AM, in article > 1166518076.224067.285250@t46g2000cwa.googlegroups.com, "PhilD" [quoted text clipped - 44 lines] > OS 10.4.7 > Office 2004 Actually it did not work. The cells are now white, but text wont type in them. OS 10.4.7 Office 2004 On 12/20/06 7:23 PM, in article C1AF3E40.1EB6C%studiok4485@hotmail.com, > On 12/19/06 8:49 PM, in article C1AE00E2.1EAEB%studiok4485@hotmail.com, > [quoted text clipped - 54 lines] > OS 10.4.7 > Office 2004 BUT NOW ALL THESE CELLS WONT ACCEPT TEXT. YOU TYPE INTO THEM AND NOTHING HAPPENS, ALTHOUGH THE TEXT DOES SHOW IN THE FORMULA BAR. OS 10.4.7 Office 2004 > BUT NOW ALL THESE CELLS WONT ACCEPT TEXT. YOU TYPE INTO THEM AND NOTHING > HAPPENS, ALTHOUGH THE TEXT DOES SHOW IN THE FORMULA BAR. > OS 10.4.7 > Office 2004 If the text shows in the formula bar, then it is "there", and something *does* happen. Suggest looking at text colour: make sure it's something other than white. If it's "automatic", change it to something dark, just to be sure. Also, please don't shout. PhilD -- <>< On 12/21/06 12:31 AM, in article 1166689916.235088.19880@42g2000cwt.googlegroups.com, "PhilD" <phildeaves@yahoo.co.uk> wrote: >> BUT NOW ALL THESE CELLS WONT ACCEPT TEXT. YOU TYPE INTO THEM AND NOTHING >> HAPPENS, ALTHOUGH THE TEXT DOES SHOW IN THE FORMULA BAR. [quoted text clipped - 12 lines] > -- > <>< Thanks Phil, it seems that the font was white. Why was it white? It's like asking why did I get the yellow bars. OS 10.4.7 Office 2004 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.