Hello,

Sign up to join our community!

Welcome Back,

Please sign in to your account!

Forgot Password,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Sorry, you do not have permission to ask a question, You must login to ask a question.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Home Latest Topics

  • 14k
  • 14k
Kevin Stratvert

3 Amazing Excel Features… most people don’t know 😺

video
play-rounded-fill

Three Excel features that most people just don’t know about. Number one. Click into a cell and then go up to the name box in the top left-hand corner. You can give your cell a name. Now you could just reference your cell just by using that name. Press CTRL + F3 and that opens up the name manager where you can see all of your different defined names. Number two. Click on some data and then press CTRL together with T. This turns it into a table. You get this beautiful formatting. You can also very quickly filter all of your columns, and down at the bottom, you can run some different calculations. Here I’ll select SUM. And number three. Press CTRL together with (;) semi colon and that inserts the current date. Press CTRL + Shift + (;) semi colon and that inserts the current time. This is something you’ll end up using all the time. So, how many of these did you know?

Related Topics

You must login to add an answer.

Hide picture