Pls help newbie Excel Starter 2010

Hi Azurepink, welcome to 7F! :)

Try this page: Excel 2010 Sorting Data be sure to check out the video to the right visuals make learning easier.

Check out the multiple columns section here: Excel Easy | Sort

And here is a YouTube search: Sorting in Excel 2010

You're welcome.

I use Libre Office but all the "office" programs are basically the same.

• Just make sure all the columns are selected, left click/hold on the A column and highlight across to the last column that has the data you want to sort.

• Then go up to the menu bar and click on Data >Sort, make sure your first sort key says Column A and the rest of the columns will follow "A".

• If it doesn't look right you can always click on the "Undo" button.

• Practice makes perfect.

By the way; If you would feel better if this thread was in the right Forum go to the upper right corner of any of your replies and click on the icon and write a short note to the Administrators or Moderators and ask to have your thread moved to the Microsoft Office Forum.

Anak (or anyone),
Could you answer another Q for me please?
My spreadsheet is 500 rows long and goes to column AS. I have to make the document into two now. (ie from rows 293 to 500).
Can you please tell me how to do this keeping all info including the first column as when I tried it the first column just has a row of ##### instead of all the dates I put in. And how to copy and paste it into a new spreadsheet. I have created the new blank document and tried this but it didn't look right. Hope you can understand this.
Many thanks.

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.

You're welcome.