by Essential Excel | Feb 19, 2021 | Tips and Tricks

Navigation Shortcuts CTRL + LEFT/RIGHT/UP/DOWN: Move to the next populated cell CTRL + END: Move to the last populated cell CTRL + HOME: Return to Cell A1 CTRL + G: Go to a specific cell by entering the address CTRL + PAGE DOWN: Go to the next spreadsheet CTRL + PAGE...
by Essential Excel | Mar 9, 2018 | Tips and Tricks

Here is a quick solution for counting number of words in given cell. There is picture with example and belov is formula that you can paste into your Sheet, and just change cell that you want to count words. Example for getting number of words in cell A2:...
by Essential Excel | Nov 18, 2016 | Tips and Tricks

Number of Saturdays in Month or Given Period Here are a quick example how to determinate number of Saturdays for month or given period of time with excel formula. First in one cell, in our example it will be A1, put start time for desired period of time, then in...
by Essential Excel | Nov 8, 2016 | Tips and Tricks

Get Current Workbook Path With Excel Formula If you have open Workbook and cant remember where it is on your HDD there are excel formula that can help you fast. =CELL(“filename”)...
by Essential Excel | Nov 3, 2016 | Tips and Tricks

Generate a set of unique numbers in random order To generate random numbers in Excel between 1 to 20, where none of the numbers repeat, we can use the excel function RAND(). In cell A1 type formula =RAND() and drag formula to cell A20. You will get a list of random...
by Essential Excel | Nov 3, 2016 | Tips and Tricks

Split Text With Excel Formula Into Two Columns To split text with excel function, you can use combination of four excel function. Here are list of function that we will use: LEFT RIGHT LEN FIND In cell A1 type text “Fuel+Car”. So we want to split text...
## Recent Comments