In Excel 2007, how do I add a column to the left of a column when there is only 3?

A

Advice Pro

I hid all but three columns and if I right-click on column A to insert a column, it becomes column B and no column is to the left.
 

My Computer

richc46

Vista Guru
Gold Member
Re: In Excel 2007, how do I add a column to the left of a column when there is only 3

I have Excel 2007
I put the cursor in column A, right click, and then insert.
Insert entire column. It appears to the left. Is this what you are doing
 
Last edited:

My Computer

System One

  • Manufacturer/Model
    Dell XPS420
    Memory
    6 gig
    Graphics Card(s)
    ATI Radeon HD3650 256 MB
    Sound Card
    Intergrated 7.1 Channel Audio
    Monitor(s) Displays
    Dell SP2009W 20 inch Flat Panel w Webcam
    Hard Drives
    640 gb
    Cooling
    Fan
    Mouse
    Dell USB 4 button optical
    Keyboard
    Dell USB
    Other Info
    DSL provided by ATT
A

Advice Pro

Re: In Excel 2007, how do I add a column to the left of a column when there is only 3

That's what I'm doing, but a column doesn't appear. What happens is that the first column becomes column B:

 

My Computer

richc46

Vista Guru
Gold Member
Re: In Excel 2007, how do I add a column to the left of a column when there is only 3

quite obvious there is a problem, give this a try. Not a fix, but a work around.
Rather than use insert column, try to move everything to the right, then save close and then try insert.
Be sure to get back to me, I am curious to find out if this may be a solution.
 

My Computer

System One

  • Manufacturer/Model
    Dell XPS420
    Memory
    6 gig
    Graphics Card(s)
    ATI Radeon HD3650 256 MB
    Sound Card
    Intergrated 7.1 Channel Audio
    Monitor(s) Displays
    Dell SP2009W 20 inch Flat Panel w Webcam
    Hard Drives
    640 gb
    Cooling
    Fan
    Mouse
    Dell USB 4 button optical
    Keyboard
    Dell USB
    Other Info
    DSL provided by ATT

townsbg

~~тσωηsвg~~
Vista Guru
Gold Member
Re: In Excel 2007, how do I add a column to the left of a column when there is only 3

I get the same thing and that is because all other columns are hidden. If you note when you insert a column A becomes B. If you unhide the columns or you can select B and drag to the left, click unhide and then you see A.
 
Last edited:

My Computers

System One System Two

  • Operating System
    Windows 7 Pro x64
    Manufacturer/Model
    Mid 2010 iMac
    CPU
    Quad core 3.2 Ghz Intel I3
    Memory
    8 gb
    Graphics Card(s)
    ATI Radeon HD 5670 512 mb ram
    Screen Resolution
    1920x1080 and 1440x900
    Hard Drives
    1 TB
    Other Info
    N/A
  • Operating System
    Windows 2012 R2 Data center/Linux Mint
    Manufacturer/Model
    Poweredge T140
    CPU
    i3 9100 3.6GHz, 8M cache, 4C/4T
    Memory
    8GB 2666MT/s DDR4 ECC UDIMM
    Screen Resolution
    1440 x 900
    Hard Drives
    1 TB & 360 GB
Top