• Sign in
  • Sign up 
  • Welcome
  • FAQ
  • Block Explorer 
  • Night Mode
  • Stolen Accounts Recovery 
  • Change Account Password 
  • Vote for Witnesses 
  • Hive Proposals 
  • OpenHive Chat 
  • Developer Portal 
  • Hive Whitepaper 
  • Privacy Policy
  • Terms of Service
logo
  • Posts
  • Proposals
  • Witnesses
  • Our dApps
LoginSign up

6 Excel Tricks to Make Life Easier

theexcelclub (67)in Excel For All • 6 years ago (edited)
#excel #stemgeeks #palnet #steemleo
6 years ago in Excel For All by theexcelclub (67)
$4.60
  • Past Payouts $4.60
  • - Author $2.38
  • - Curators & beneficiaries $2.21
  • > steempress: $0.34
166 votes
  • steempress-io: $2.39
  • znnuksfe: $0.53
  • paulag: $0.27
  • howo: $0.15
  • steemflagrewards: $0.14
  • helpie: $0.11
  • exyle: $0.09
  • abh12345: $0.07
  • theexcelclub: $0.07
  • leo.voter: $0.07
  • cryptocurator: $0.05
  • deathcross: $0.05
  • steempress: $0.05
  • eonwarped: $0.05
  • edkarnie: $0.04
  • traciyork: $0.04
  • amico: $0.03
  • dalz: $0.03
  • edriseur: $0.03
  • steem.leo: $0.02
  • and 146 more
Reply 2
Sort:  
  • Trending
    • Trending
    • Votes
    • Age
  • [-]
    xlncad (46)
     6 years ago  

    Another quick way to Navigate through sheets is by using Excel Name Box.
    To select a cell in another sheet from the active sheet, Type in the SheetName and Cell reference in the Excel Name box and press Enter.
    Excel NameBox.png

    $0.23
    • Past Payouts $0.23
    • - Author $0.11
    • - Curators $0.11
    2 votes
    • paulag: $0.18
    • theexcelclub: $0.05
    Reply
    [-]
    theexcelclub (67)
     6 years ago  

    Naming is something most don't do in Excel, although I think using names adds a lot of value

    $0.00
      1 vote
      • xlncad
      Reply