top of page
Search

Excel tricks learned this week

  • Writer: Lei
    Lei
  • Jan 11, 2019
  • 1 min read

Customize the "Quick Access Toolbar" on top left, then you can command+shift+number of the command(from left to right, starts with 1) to use that command


option + click the sheet name to copy the sheet


When there's empty cell in a column and you want to sort it, a window will pop up and you select "expand to all" to correct sort (the empty cells will end up at the bottom)


 
 
 

Recent Posts

See All
Why are most web hyperlinks blue?

"Red and green are the colors most affected by color-vision deficiency. Almost no one has a blue deficiency. That means almost everyone...

 
 
 
Practice active listening

I hear... (what you are saying) I can feel... (your emotions/intentions) I understand you're trying to... (your wish/goal/motivation)...

 
 
 

Commentaires


© 2018 by Lei Wang. Proudly created with Wix.com

bottom of page