ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can no longer insert new columns & unhide hidden columns (https://www.excelbanter.com/excel-worksheet-functions/150815-can-no-longer-insert-new-columns-unhide-hidden-columns.html)

em2

can no longer insert new columns & unhide hidden columns
 
I can no longer insert new columns in between previously formed columns, and
can't unhide the hidden columns. Using excel help did not help. Any
suggestions?

Dave Thomas

can no longer insert new columns & unhide hidden columns
 
To unhide all the hidden columns, select the entire spreadsheet by clicking
on the square just above the row 1 and to the right of column A, or by
pressing CTRL+a in Excel 2007 or CTRL+a (twice sometimes) in Excel 2003. In
excel 2003 then select the Format menu, then column, then unhide. In Excel
2007, Home Tab, Cells section, Format, Hide & Unhide, Unhide Columns.

Do you get a message when you try to insert columns?

"em2" wrote in message
...
I can no longer insert new columns in between previously formed columns,
and
can't unhide the hidden columns. Using excel help did not help. Any
suggestions?





All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com