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.
In Excel 2007, how do I add a column to the left of a column when there is only 3?
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
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:
That's what I'm doing, but a column doesn't appear. What happens is that the first column becomes column B:
My Computer
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.
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
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.
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 8.1 Industry Pro x64
- Manufacturer/Model
- HP Pavillion Elite HPE-250f
- CPU
- Intel i7 860 Quad core 2.8 ghz
- Memory
- 8 gb
- Graphics card(s)
- ATI Radeon HD 5770 1 gb ram
- Monitor(s) Displays
- Alienware 25 AW2521HF
- Screen Resolution
- 1920x1080 &1680x1050
- Hard Drives
- 1 TB x2
- Other Info
- https://www.cnet.com/products/hp-pavilion-elite-hpe-250f/
-
- Operating System
- Windows 2012 R2 Data center/Linux Mint
- Manufacturer/Model
- Dell Poweredge T140
- CPU
- i3 9100 3.6GHz, 8M cache, 4C/4T
- Memory
- 8GB 2666MT/s DDR4 ECC UDIMM
- Screen Resolution
- 1680x1050
- Hard Drives
- 1 TB & 360 GB x2
- Other Info
- https://www.dell.com/en-us/work/shop/productdetailstxn/poweredge-t140?~ck=bt