If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Micrososft Excel Question

GerryRyan · 2007-10-27 16:27:26

Trying to edit or limit the amount of rows/columns in Microsoft Excel spreadsheet (2002 version). Worksheet and workbook specifications: Worksheet size 65,536 rows by 256 columns -- > standard How do I cut this down to 500 rows x 20 columns? Not asking about the page break preview option.

27-10-2007 4:27pm

#1

GerryRyan

Closed Accounts Posts: 966 ✭✭✭

Join Date: October 2005

Posts: 774

Trying to edit or limit the amount of rows/columns in Microsoft Excel spreadsheet (2002 version).

Worksheet and workbook specifications:

Worksheet size 65,536 rows by 256 columns -- > standard

How do I cut this down to 500 rows x 20 columns?
Not asking about the page break preview option.

0

Comments

#2 27-10-2007 4:57pm

Capt'n Midnight

Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 93,567 Mod ✭✭✭✭

Join Date: March 2003

Posts: 91805

could you protect the remaining cells so people can't use them ?

0
#3 28-10-2007 9:36pm

hamster

Registered Users, Registered Users 2 Posts: 1,766 ✭✭✭

Join Date: November 2002

Posts: 1381

You could also try the Excel Forums for more ideas. I found them excellent!

0