Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
view entire workbook
I have a worksheet with mutlitple columns, is there any way to view the
entire worksheet at once without using the slide to view from one end to the other? Any help is greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
view entire workbook
You could adjust the zoom level to 50% (or smaller) to see more
columns, though it will be difficult to make out the detail of each cell. Pete On Dec 7, 5:30*pm, cgrose54 wrote: I have a worksheet with mutlitple columns, is there any way to view the entire worksheet at once without using the slide to view from one end to the other? *Any help is greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
view entire workbook
You may or may not like the results but put this is the ThisWorkbook module
to do every sheet Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveSheet.UsedRange.Select ActiveWindow.Zoom = True Range("a1").select End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "cgrose54" wrote in message ... I have a worksheet with mutlitple columns, is there any way to view the entire worksheet at once without using the slide to view from one end to the other? Any help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name an Entire Workbook | Excel Discussion (Misc queries) | |||
No entire view in edited shift dropdown list Nursing Schedule Exc | New Users to Excel | |||
should be possible to view entire MS Word embedded object in MS E. | Excel Discussion (Misc queries) | |||
Why can't I see my entire formatted merged cell in print view eve. | Excel Discussion (Misc queries) | |||
how can I view the entire worksheet when the row numbers are blue | Excel Worksheet Functions |