Hottest Free Downloads - DownloadPipe.com Over 197,000 downloads! Bookmark Now!
DownloadPipe.com - New Downloads Every Minute
 SEARCH:
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

setting parameters for worksheet

 
   Mac (Home) -> Mac Excel RSS
Next:  Changing Maximum in Format Axis Scale dialog  
Author Message
calc

External


Since: Jan 01, 2009
Posts: 1



(Msg. 1) Posted: Thu Jan 01, 2009 12:20 pm
Post subject: setting parameters for worksheet
Archived from groups: microsoft>public>mac>office>excel (more info?)

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I'm trying to set up an Excel worksheet and cannot figure out how to set the number of columns and rows that I need. I've highlighted the (11,000+) columns that I don't need and clicked Edit & Delete, but nothing happens. What else can I do? Help!
Back to top
Login to vote
CyberTaz

External


Since: May 06, 2006
Posts: 1251



(Msg. 2) Posted: Thu Jan 01, 2009 3:02 pm
Post subject: Re: setting parameters for worksheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The number of columns & rows is fixed - those numbers cannot be increased or
decreased. "Deleted" columns or rows are simply moved out to the respective
edge & the gap closes up. The simplest [and perhaps most common] approach is
to just use those you need & ignore the rest... They don't print unless you
choose to do so nor do they increase the size of the file

There are methods of hiding or disguising the additional columns & rows but
unless you're designing some sort of form (invoice, calendar, planner, etc.)
it's probably more trouble than it's worth.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 1/1/09 2:20 PM, in article 59b684b4.-1.TakeThisOut@webcrossing.caR9absDaxw,
"calc@officeformac.com" <calc.TakeThisOut@officeformac.com> wrote:

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
>
> I'm trying to set up an Excel worksheet and cannot figure out how to set the
> number of columns and rows that I need. I've highlighted the (11,000+) columns
> that I don't need and clicked Edit & Delete, but nothing happens. What else
> can I do? Help!
Back to top
Login to vote
Display posts from previous:   
Related Topics:
New worksheet with list - I have created a new document in Excel and inserted a new List. Now in the list wizard I have made a new list on a new work sheet. When you do this it seems to make a blank worksheet with only the columns you specified within the wizard... This worksheet...

Worksheet find - Can I make worksheet2 import all rows from worksheet1 that include the text "- Brice" ? How? dzelnio

Phantom Worksheet Puzzle. - I have created a new spreadsheet in Excel 2000 which involved some copying and pasting from a previous spreadsheet. There are multiple worksheets in the xls. Its fairly complex so don't want to recreate the whole thing again. At one point the copy of a...

Shortcut for Next/Previous Worksheet - I'm trying to find a keyboard shortcut for selecting the next or previous worksheet tab in a workbook. I've looked at the XL Help for keyboard shortcuts and it states that "ctrl + page up/page down" will move to next or previous worksheet. I've...

Condition based on worksheet visibility? Please help! - I have workbook containing several worksheets (Excel for Mac 2004). I would like to create formula in cell(s) on one worksheet based on visibility (hidden status) of other individual worksheets. Let's say if the particular worksheet is hidden, set value....
       Mac (Home) -> Mac Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
Categories:
 Windows Forums
 Game Forums
 Linux Forums
  Mac Forums
 PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact