Excel Tips and Tricks

in excel •  7 years ago 
  1. ALT+= Inserts a SUM formula.
  2. CTRL+TAB Switches between open Excel windows.
  3. CTRL+A – this has various scenarios:
    a. If you are in regular data range and press CTRL+A all the data is selected.
    b. If you press CTRL+A a second time in the same range selects the entire spreadsheet.
    c. If you are in a table then pressing the CTRL+A key selects the data excluding the total row
    AND titles.
    d. If you press the CTRL+A key a second time it selects the data, titles, and total row
    e. It does not make any difference whether the spreadsheet contains data or not, if you are
    outside the data area, in a blank area with no directly adjacent cells containing data,
    CTRL+A selects the entire sheet.
    f. If you have one or more objects e.g. Charts, selected then pressing CTRL+A selects them all.Excel.png
excel workbook tips and tricks
7 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.00
    5 votes
    0
    Authors get paid when people like you upvote their post.
    If you enjoyed what you read here, create your account today and start earning FREE STEEM!