LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
seadragon69
 
Posts: n/a
Default Rows & Columns in Excel

Ok I have worked with Excel for quite awhile. I am now in an office that is
strictly a MacIntosh environment and for the most part Excel works the same
but with a few quirks. My main problem is that every time I open a
worksheet, it is giving me all 65,000 rows and I will never use all of them.
I know there is a way to set the worksheet to open with a certain # of
columns and a certain # of rows. If I want more rows, then I can add them.
You can easily insert more columns, but I can't remember or find the step
where you can select how many rows you want in the worksheet.

For example, we do a lot of spreadsheets with name/address information.
Maybe we will type 1000 names - 1000 rows. However the sheet opens with
65000 rows - which I don't need and when we try to change anything in the
file, it tells us there is not enough memory to even do a simple function
(like deleting a row or more) because of the #of rows in the worksheet -
HELP!!!!!!!!!!!!!!!!!!!!!!!

I know there is an easy way to do this, but my memory is drawing a blank and
I can't find the info in the help section.

Thanks,

 
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
How can I transpose rows to columns in a large worksheet? ratchick Excel Discussion (Misc queries) 7 November 11th 05 04:25 PM
convert columns to rows & rows to columns ROCKWARRIOR Excel Discussion (Misc queries) 2 September 23rd 05 06:31 PM
Excel - columns into rows Richard Pace Excel Discussion (Misc queries) 4 March 19th 05 01:36 PM
Excel - Columns into rows Richard Pace New Users to Excel 5 March 19th 05 03:29 AM
In Excel, how do I change the rows into columns? Novice SS User Excel Discussion (Misc queries) 1 February 7th 05 11:13 PM


All times are GMT +1. The time now is 10:09 AM.

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"