Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Column "A" in an Excel Spreadsheet
I've tried the "GoTo" function and the "change column width" to unhide
Column A, but that's not working. Any other suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Column "A" in an Excel Spreadsheet
Click on Column B's header and "swipe" left. This will select Column A and
Column B. Just right click the selection and click Unhide. Rick "Jess" wrote in message ... I've tried the "GoTo" function and the "change column width" to unhide Column A, but that's not working. Any other suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Column "A" in an Excel Spreadsheet
Make sure that you haven't frozen the panes so that you can't scroll to column
A. In xl2003: Window|Unfreeze panes and scroll to the left Jess wrote: I've tried the "GoTo" function and the "change column width" to unhide Column A, but that's not working. Any other suggestions? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Column "A" in an Excel Spreadsheet - another case
I've tried:
1. Using - Go To:A1, then using Format/Column/Unhide. 2. Highlighting the hidden column "A" by moving black down-arrow cursor from column B to include column A, right'click "Unhide". Note that is is clear that "A" is included from two indicators - the column count that appears above the cursor - roughly where the Named Range box sits - and by the change in thickness of the vertical line between the Excel's row numbers column and column "B". 3. As in 2. above, highlighting the hidden column by moving black down-arrow cursor from column B to include column A, then using Format/Column/Unhide. 4. Customising the View through the View menu, ticking the box "Include Hidden Columns". I've also proven the on-going existence of column A by merging a cell in column "A" with one in column "B" and typing in text that goes across both columns. Jes wrote: Missing Column "A" in an Excel Spreadsheet 24-Aug-08 I've tried the "GoTo" function and the "change column width" to unhide Column A, but that's not working. Any other suggestions? EggHeadCafe - Software Developer Portal of Choice Windows Forms ListBox - 101 http://www.eggheadcafe.com/tutorials...istbox--1.aspx |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Column "A" in an Excel Spreadsheet - another case
Hi
Click on column B (the Column label) and drag left with the mouse while you hold down left mouse button. You have now selected 2 columns (A:B) and column A can be unhidden. Hopes this helps. .... Per "David Crothers" skrev i meddelelsen ... I've tried: 1. Using - Go To:A1, then using Format/Column/Unhide. 2. Highlighting the hidden column "A" by moving black down-arrow cursor from column B to include column A, right'click "Unhide". Note that is is clear that "A" is included from two indicators - the column count that appears above the cursor - roughly where the Named Range box sits - and by the change in thickness of the vertical line between the Excel's row numbers column and column "B". 3. As in 2. above, highlighting the hidden column by moving black down-arrow cursor from column B to include column A, then using Format/Column/Unhide. 4. Customising the View through the View menu, ticking the box "Include Hidden Columns". I've also proven the on-going existence of column A by merging a cell in column "A" with one in column "B" and typing in text that goes across both columns. Jes wrote: Missing Column "A" in an Excel Spreadsheet 24-Aug-08 I've tried the "GoTo" function and the "change column width" to unhide Column A, but that's not working. Any other suggestions? EggHeadCafe - Software Developer Portal of Choice Windows Forms ListBox - 101 http://www.eggheadcafe.com/tutorials...istbox--1.aspx |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Column "A" in an Excel Spreadsheet - another case
maybe column width is 0.
go to A1 on menu formatcolumnwidth auto fit selection "Per Jessen" wrote: Hi Click on column B (the Column label) and drag left with the mouse while you hold down left mouse button. You have now selected 2 columns (A:B) and column A can be unhidden. Hopes this helps. .... Per "David Crothers" skrev i meddelelsen ... I've tried: 1. Using - Go To:A1, then using Format/Column/Unhide. 2. Highlighting the hidden column "A" by moving black down-arrow cursor from column B to include column A, right'click "Unhide". Note that is is clear that "A" is included from two indicators - the column count that appears above the cursor - roughly where the Named Range box sits - and by the change in thickness of the vertical line between the Excel's row numbers column and column "B". 3. As in 2. above, highlighting the hidden column by moving black down-arrow cursor from column B to include column A, then using Format/Column/Unhide. 4. Customising the View through the View menu, ticking the box "Include Hidden Columns". I've also proven the on-going existence of column A by merging a cell in column "A" with one in column "B" and typing in text that goes across both columns. Jes wrote: Missing Column "A" in an Excel Spreadsheet 24-Aug-08 I've tried the "GoTo" function and the "change column width" to unhide Column A, but that's not working. Any other suggestions? EggHeadCafe - Software Developer Portal of Choice Windows Forms ListBox - 101 http://www.eggheadcafe.com/tutorials...istbox--1.aspx |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Column "A" in an Excel Spreadsheet - another case
Hi,
Maybe the column isn't hidden at all, perhaps it is just set very narrow, in which case unhide doesn't work F5 goto A1. Format column width and set to (say) 8 Mike "David Crothers" wrote: I've tried: 1. Using - Go To:A1, then using Format/Column/Unhide. 2. Highlighting the hidden column "A" by moving black down-arrow cursor from column B to include column A, right'click "Unhide". Note that is is clear that "A" is included from two indicators - the column count that appears above the cursor - roughly where the Named Range box sits - and by the change in thickness of the vertical line between the Excel's row numbers column and column "B". 3. As in 2. above, highlighting the hidden column by moving black down-arrow cursor from column B to include column A, then using Format/Column/Unhide. 4. Customising the View through the View menu, ticking the box "Include Hidden Columns". I've also proven the on-going existence of column A by merging a cell in column "A" with one in column "B" and typing in text that goes across both columns. Jes wrote: Missing Column "A" in an Excel Spreadsheet 24-Aug-08 I've tried the "GoTo" function and the "change column width" to unhide Column A, but that's not working. Any other suggestions? EggHeadCafe - Software Developer Portal of Choice Windows Forms ListBox - 101 http://www.eggheadcafe.com/tutorials...istbox--1.aspx |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Column "A" in an Excel Spreadsheet - another case
Have you tried Window|UnFreeze
Then scrolling to the left? David, Crothers wrote: I've tried: 1. Using - Go To:A1, then using Format/Column/Unhide. 2. Highlighting the hidden column "A" by moving black down-arrow cursor from column B to include column A, right'click "Unhide". Note that is is clear that "A" is included from two indicators - the column count that appears above the cursor - roughly where the Named Range box sits - and by the change in thickness of the vertical line between the Excel's row numbers column and column "B". 3. As in 2. above, highlighting the hidden column by moving black down-arrow cursor from column B to include column A, then using Format/Column/Unhide. 4. Customising the View through the View menu, ticking the box "Include Hidden Columns". I've also proven the on-going existence of column A by merging a cell in column "A" with one in column "B" and typing in text that goes across both columns. Jes wrote: Missing Column "A" in an Excel Spreadsheet 24-Aug-08 I've tried the "GoTo" function and the "change column width" to unhide Column A, but that's not working. Any other suggestions? EggHeadCafe - Software Developer Portal of Choice Windows Forms ListBox - 101 http://www.eggheadcafe.com/tutorials...istbox--1.aspx -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
Signature missing when "send to" "mail recipient" | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) |