LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Formula Bar blocks column header letters so I can't paste

I've run into a problem while trying to move a couple of columns in an
Excel 2003 worksheet.

I'm trying to move columns J & K a couple of columns over to the right
and insert them to the left of column N.

Here's what happens:

1. I put the mouse pointer over the letter J at the top of the column
and click the left mouse button.

2. As I would expect, all the cells in the column turn blue, and
heavy dark vertical borders appear along the sides of the column.

3. But, a horizontal white bar pops up along the top edge of the
worksheet and obscures all of the alphabetical column header letters,
so I'm unable to see the letter of column N (or any of the other
columns for that matter) so I'm not able to click on column N in order
to insert the column.

4. When I put the mouse pointer inside the annoying white bar, a
little label pops up saying "formula bar"

How can I make this white bar go away so I can see the letters at the
tops of the columns?

Will in Seattle
a.k.a. "Clueless"
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula bar obscures top of column letters Ted M H Excel Discussion (Misc queries) 0 August 18th 07 10:12 PM
Multiple blocks (double column lists) turned into drop down list Mister_Paul_K Excel Discussion (Misc queries) 0 March 30th 07 10:00 AM
formula for column letters BorisS Excel Discussion (Misc queries) 3 December 7th 06 08:51 AM
How do change a column of data in capitol letters to small letters Barb P. Excel Discussion (Misc queries) 6 November 15th 06 06:17 PM
Excel: custom header - is it possible to paste into header? Maureen D. Excel Worksheet Functions 0 November 4th 05 03:07 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"