Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 56
Default Modify Spreadsheet View

I have just imported finance data into a spreadsheet. It went well but there
are columns in the view that have no data. If I could eliminate columns L
to the end the remaining columns would be larger. I also see 'page tabs'
where there is apparently no data as well. Would their elimination allow me
to see more data? Please advise
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default Modify Spreadsheet View

Maurice

You cannot eliminate unused columns to make the other columns wider.

You can widen your data columns by just dragging on the column header or
selecting them and FormatColumnWidth........enter a number.

Eliminating the extra sheet tabs will not make the veiwed sheet any larger.

You could set the zoom to something less than 100% but this will make your
cells/fonts smaller and harder to read.


Gord Dibben MS Excel MVP


On Fri, 9 Mar 2007 18:05:03 -0800, Maurice
wrote:

I have just imported finance data into a spreadsheet. It went well but there
are columns in the view that have no data. If I could eliminate columns L
to the end the remaining columns would be larger. I also see 'page tabs'
where there is apparently no data as well. Would their elimination allow me
to see more data? Please advise


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tree View of spreadsheet tabs: is it possible? [email protected] New Users to Excel 2 June 1st 06 10:26 PM
How do I Modify The XML View Options eroc New Users to Excel 0 May 2nd 06 04:11 AM
spreadsheet contents have become hidden from view clive Excel Discussion (Misc queries) 2 March 23rd 06 08:40 AM
Why can I only view my spreadsheet in full screen gloria81101 Excel Discussion (Misc queries) 1 October 14th 05 07:00 PM
How do I modify the spreadsheet to fit less rows per page? LeeAnn Excel Discussion (Misc queries) 1 May 16th 05 09:40 PM


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"