Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

labels

ResolvedVersion 2003

Ash has attended:
Excel Introduction course

Labels and Vlaues

Why do labels default to the left and values default to the right on excel spreadsheets?

RE: Labels and Vlaues

Hi Ash,
Thank you for the post, welcome to the forum, I hope you enjoyed todays course.
To answer your question;
Sometimes numbers can look like numbers when they are infact text. ie a number which has been formatted as text.
All numbers should be right aligned by default
If numbers are left aligned then they are probably being interpreted as text.
It is not possible to perform calculations on any numbers that are being interpreted (or formatted) as text
Dont forget if you dont want them different all you need to do is to select them and apply either left, right or centre alignment,
Hope that helped, regards Pete

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.