Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Pls help newbie Excel Starter 2010

12 Jul 2015   #1
Azurepink

Windows 7
 
 
Pls help newbie Excel Starter 2010

Could someone pls direct me to where I can get help re a formatting question with Excel Starter 2010? I know this is the Chillout Room and not the correct place. (I want to put my data in date order with the corresponding info in the rows also moved. I don't want to just sort one column, I want all the corresponding info attached in the rows to move also if you understand my question). Many thanks for taking the time.


My System SpecsSystem Spec
.
15 Jul 2015   #2
Anak

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

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
My System SpecsSystem Spec
16 Jul 2015   #3
Azurepink

Windows 7
 
 

Hi Anak,
Thank you so much for responding and posting the links. Very much appreciated.
My System SpecsSystem Spec
.

16 Jul 2015   #4
Anak

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

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.
My System SpecsSystem Spec
04 Aug 2015   #5
Azurepink

Windows 7
 
 
Highlighting problems

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 System SpecsSystem Spec
04 Aug 2015   #6
Anak

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

Quote:
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   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   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.
My System SpecsSystem Spec
04 Aug 2015   #7
Azurepink

Windows 7
 
 

Thank you so much. You are very helpful. Problem solved. Very grateful for your valued assistance. Yes I save my doc many times. I will save your advice for reference. A1 and 5 Star service from you
My System SpecsSystem Spec
04 Aug 2015   #8
Anak

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

You're welcome.
My System SpecsSystem Spec
Reply

 Pls help newbie Excel Starter 2010




Thread Tools




Similar help and support threads
Thread Forum
Word Starter Excel missing some gridlines
Hi all I am trying to create a Excel document with Office Starter. However, some of the gridlines disappeared as I was working on it. Note: only some of them. I want to be able to print the gridlines, but they are still missing in print preview. Nothing I have tried has brought it back. Any...
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
MSO10 Starter won't read Excel 2003 files
Computer 1: Windows 7 sp1 & Office 2010 Starter After Patch Tuesday 9/10/2013, Excel 2010 is no longer able to read Excel 2003 files. In fact, all Excel 2003 files have changed from the standard Excel Icon to a non-standard orange Icon. Attempts to open these files will bring up the Install...
Microsoft Office
How to edit/delete "Comments" in Excel 2010 Starter?
I'm working with a 1997-2003 Compatibility View spreadsheet in Excel Starter and I use Comments (the little windows to pop-up when you hover the mouse over a cell) throughout. I don't see how to edit or delete them, when I right-click, it only gives me "show/hide" them. Thanks!
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Visio 2010 Newbie
Hello folks. Okay, this might be really simple, or incredibly difficult. I'll explain the best I can. I have a background picture of an office map in Visio 2010. Out of courtesy to my office, I want to make a map that will update in accordance to the information listed on an Access Database....
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:48.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App