My spreadsheet is 500 rows long and goes to column AS
Slowdown, you're mixing apples and oranges here. Rows are numerical; Columns are alphabetized. I believe the word "long" is throwing me off.
Some questions:
1.) Do you mean to say your sheet is 500 rows deep and it extends out to column AS?
2.)
Why do you need to break it up into two separate worksheets/Books? No matter.
3.) The reason you're seeing hash marks (####) is because the column that contains the dates or any other name or value is too narrow. You can either place the cursor over the column line/border between column A and B until it changes to a black line with a double arrow then double click and the A column should expand to reveal the dates, if that doesn't work just left click and hold to drag the column a little wider until you see the dates, names or values.
3a.) This also works to expand rows if names or values look "chopped off". Place the cursor over the border between rows until you see the "black bar double arrow" cursor then double click or drag.
4.) If you still need to make another worksheet it would be easier to make two copies of the original then delete out the rows you don't need. (
always keep your original for backup)
4a.) Right click on the sheet tab at the bottom, a context menu should open to Move or Copy the sheet, place the copy at the end of the original, it will be re-named as the original only it will have this at the end (2) to signify the difference. Double click on the sheet name tab to rename it. You will have to do this twice. Sheets (2) (3).
4b.) In your first copy delete the rows from 293 to 500 and that will give you the original rows 1 to 292;
4c.) In the second copy delete the rows 1 to 292 and that will give you rows 293 to 500, but they will become rows 1 to 208 if I figured correctly.
I know 4b and 4c sound confusing/backwards, but stop and think about it, and if you mess up you always have the original right? You did remember to save the original, didn't you?
One more thing, remember to save, save, save. There should be a setting in tools or somewhere to automatically save every few minutes or so, but I never liked it because you might be in the middle of an entry and have to wait for the save setting to finish, so I just got used to saving on my own. You never know when disaster may strike like a power failure and ruin 10 to 15 minutes of input.
I usually save after every input, but if the input takes longer than a minute or two I'll save several times in those two minutes. Saving also gives my eyes a break from inputting.
Information
To add or delete rows or columns; Place the mouse cursor on the beginning row or column and while holding the left mouse button, move the cursor down (rows) or across (columns) to the desired limit, let go then place the cursor on any row or column and right click to bring up the context menu to either add or delete columns or rows.
Deleting rows or columns is straight forward just pick what you want deleted and it's gone, everything that remains is either moved up (rows) or to the left (columns) and they assume the previous numbering or lettering.
When adding rows or columns the number of rows or columns you pick will be the number added, what remains is either moved down (rows) or to the right (columns) and any previously occupied rows or columns will be given new numbering or lettering;
Tip
Be careful that you do not go beyond what you want to delete when deleting, it's gone unless you "undo the last action"; But, you can highlight over an occupied row or column when adding rows or columns without the fear of losing anything.
