Creating a spreadsheet

Copper Contributor

Is there a way to create a spreadsheet by setting a specific number of rows and columns? I don't want all of the million extra rows/columns taking up space on the file. 

 

I'm trying to create a excel database with 19 columns and 3000 rows. 

 

Thanks for any help! I've tried all I can think of with no success.

2 Replies
Well, these rows and columns are default and system based that come as a packaged deal with Excel.

May I suggest one or both of the following.

Highlight/Select the range of columns and rows that you need (19/3000). Right-click to select Format Cell, in the dialog box, select the Protection tab, and then deselect the "Locked" option. Next, click on Review from the Ribbon Tab and select the Protect Sheet from the Protect Group. Ensure only the "Select unlocked cells" checkbox is checked. You may set a password. Click ok.

This will ensure only the 19 columns and 3000 rows are selectable while all the remaining ones will be locked.

Alternatively, you could select the column after 19th, while holding down the Control + Shift keys, use the right arrow to select all columns to the right of the col20, which end at colXFD. Then right-click and select Hide. Do the same for the rows. Move to the row below the 3000th, ctr + shift + down arrow to select everything below. Right-click and choose Hide. You are now left with only the range of cells you wanted.

Of course, there are several other solutions that might be better than either of the above. Best of luck.
The fact is that even if the other 16,000 plus columns and more than a million rows are visible, they don't take up space ... cells only use space when they're filled with data. A blank Excel file has a standard size as the 16,384 columns and 1,048,576 rows are the standard capacity per sheet, so even extra blank sheets, up to 255, don't add to the space.

I hope this clarifies. Have fun ...