ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i unhide columns after saving in excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/247489-how-do-i-unhide-columns-after-saving-excel-2007-a.html)

p-nut[_2_]

how do i unhide columns after saving in excel 2007
 
i saved a large spreadsheet after i had hidden columns. I have tried to
unhide on the format and went the the help section. no sulutions were found.

Geoff_L[_2_]

how do i unhide columns after saving in excel 2007
 
Why not try a bit of vba?

Sub Unhide()

For a = 1 To 20 'Or whatever column you need to run to
Columns(a).Hidden = False
Next a

End Sub

Helpful? Click Yes.

"p-nut" wrote:

i saved a large spreadsheet after i had hidden columns. I have tried to
unhide on the format and went the the help section. no sulutions were found.



All times are GMT +1. The time now is 07:10 PM.

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