New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Crazy Mac Excel Question


Post Reply New Thread Subscribe

 
Thread Tools
tbgiles

 
Member Since: Feb 15, 2007
Location: Denver
Posts: 7
tbgiles is on a distinguished road
Mac Specs: Macbook 13" - IMAC 20"

tbgiles is offline
So maybe i'm just really anal but I thought I would ask anyway because it is bugging me that much.

In my Excel spreadsheet, after I horizontally or vertically scroll to the end of my data, there appears a large gray area with nothing in it. I have searched everywhere on how to remove it with no luck. I have had good luck on this forum so far (which is why I will continue to buy macs) so I thought I would try. How do I get rid of this large gray area (which is now officially my nemesis) so that scrolling stops at my last column or row with data, and not clear down to the end of the gray area?

If there is no way, I will humbly accept my defeat....

Thanks for the help, and I faithfully use the reputation system.
QUOTE Thanks
CrossBones

 
Member Since: Apr 21, 2005
Posts: 766
CrossBones is a glorious beacon of lightCrossBones is a glorious beacon of lightCrossBones is a glorious beacon of lightCrossBones is a glorious beacon of lightCrossBones is a glorious beacon of lightCrossBones is a glorious beacon of light

CrossBones is offline
Not happening for me. I can scroll forever and Excel just keeps adding rows or columns as I scroll. Must be some setting I'm not aware of.
QUOTE Thanks
eric

 
eric's Avatar
 
Member Since: Nov 04, 2006
Location: twin cities, mn, usa
Posts: 8,801
eric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond reputeeric has a reputation beyond repute

eric is offline
well, it should only scroll a certain amount to the side (i want to say 255 columns, but i might be wrong), but it could go on forever (theoretically) going down.

also, are you using the arrows or the scroll bar to scroll, or are you doing it with a pointer trick? scroll bars should stop, the arrow and pointer tricks will go well past your data as you've noticed.

edit: just checked, sideways my excel stops at column IV, which if you write a 1 in either the first or last column and then incrementally copy it to the other side ends up with 256 columns.

Please participate in our Member of the Month polls. Every vote counts! And remember to use the user reputation system!
["Dear Homer, I. O. U. one emergency donut. Signed, Homer." - Note by Homer Simpson]
QUOTE Thanks
traded

 
traded's Avatar
 
Member Since: Nov 15, 2006
Location: Los Angeles
Posts: 157
traded will become famous soon enough
Mac Specs: MacBook Pro C2D 2.16

traded is offline
What version of Office are you using?
QUOTE Thanks
shades

 
Member Since: May 20, 2004
Posts: 243
shades is a jewel in the roughshades is a jewel in the rough
Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB

shades is offline
Howdy. It probably means that somehow you (or someone else) has hidden columns and rows.

You should see 256 columns (Column IV is the last), and 65,536 rows. This is true for XL 98, 2001, X, and 2004 as well as corresponding Windows versions XL 97, 2000, 2002, 2003.

If/when you upgrade to XL 2008, then you will have 16,000+ columns and 1,000,000+ rows.
QUOTE Thanks
shades

 
Member Since: May 20, 2004
Posts: 243
shades is a jewel in the roughshades is a jewel in the rough
Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB

shades is offline
If the columns or rows are hidden, to unhide all of them, click on the small square above and to the left of cell A1, which selects the entire worksheet. Then go to

Format > Row > Unhide

and

Format > Column > Unhide
QUOTE Thanks

Post Reply New Thread Subscribe


« ChitChat for Yahoo? | Firefox video problems »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
New Mac user question in regards to iTunes + current music. dak125 iPod Hardware and Accessories 6 01-15-2007 02:43 AM
New Mac User...Question on where to find software? Tazz212 OS X - Apps and Games 6 01-04-2007 09:10 PM
Question for Mini Mac owners - Software related dj_white_rice Apple Desktops 3 02-16-2006 10:49 AM
Question - Custom Mac OS X Machine djlee12 Schweb's Lounge 5 01-30-2006 12:23 AM
Mac Users Get More ISP Choices schweb Apple Rumors and Reports 1 03-06-2003 10:57 AM

All times are GMT -4. The time now is 08:05 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?