-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
[b]Save values only[/b]
- Thread starter Z-Doc
- Start date
Excel Facts
Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Right mouse click the sheet name tab to get popup menu
Left mouse click "Move or copy"
in 'To Book' - Select "New Book"
check "Create a copy"
OK
Left mouse click small grey square on the sheet where row numbers/column letter join to select the whole worksheet.
Edit/Copy
Edit Paste special/Values
Left mouse click "Move or copy"
in 'To Book' - Select "New Book"
check "Create a copy"
OK
Left mouse click small grey square on the sheet where row numbers/column letter join to select the whole worksheet.
Edit/Copy
Edit Paste special/Values
Upvote
0
Similar threads
- Solved
- Replies
- 3
- Views
- 147
- Replies
- 9
- Views
- 532
- Question
- Replies
- 16
- Views
- 650
- Replies
- 1
- Views
- 27
