ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't unhide left columns but can see them on print preview (https://www.excelbanter.com/excel-discussion-misc-queries/196942-cant-unhide-left-columns-but-can-see-them-print-preview.html)

Columnless

Can't unhide left columns but can see them on print preview
 
I have column A through G hidden. I have attempted to unhide them
unsuccessfully (Format, Columns, Unhide). But Print Preview shows the
columns to still there. Column H is the farthest left column showing.
Nether the double headed arrow or the white bar between two black lines
appears when placing the cursor on the left of Column H. How do I reveal
columns A through G again? Thanks for your help.



Mike H

Can't unhide left columns but can see them on print preview
 
Maybe they aren't hidden and they are just set to be very narrow.

Select them and then
Format|Column|Width
enter a value(say) 12 and click OK.

Mike

"Columnless" wrote:

I have column A through G hidden. I have attempted to unhide them
unsuccessfully (Format, Columns, Unhide). But Print Preview shows the
columns to still there. Column H is the farthest left column showing.
Nether the double headed arrow or the white bar between two black lines
appears when placing the cursor on the left of Column H. How do I reveal
columns A through G again? Thanks for your help.



David Biddulph[_2_]

Can't unhide left columns but can see them on print preview
 
Or you've got Frozen panes?
--
David Biddulph

"Mike H" wrote in message
...
Maybe they aren't hidden and they are just set to be very narrow.

Select them and then
Format|Column|Width
enter a value(say) 12 and click OK.

Mike

"Columnless" wrote:

I have column A through G hidden. I have attempted to unhide them
unsuccessfully (Format, Columns, Unhide). But Print Preview shows the
columns to still there. Column H is the farthest left column showing.
Nether the double headed arrow or the white bar between two black lines
appears when placing the cursor on the left of Column H. How do I reveal
columns A through G again? Thanks for your help.





Austin

Can't unhide left columns but can see them on print preview
 
Try going to window/unfreeze panes

"Columnless" wrote:

I have column A through G hidden. I have attempted to unhide them
unsuccessfully (Format, Columns, Unhide). But Print Preview shows the
columns to still there. Column H is the farthest left column showing.
Nether the double headed arrow or the white bar between two black lines
appears when placing the cursor on the left of Column H. How do I reveal
columns A through G again? Thanks for your help.




All times are GMT +1. The time now is 11:00 PM.

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