You are reading the article How To Use Excel Hacks With Keyboard Shortcuts? updated in September 2023 on the website Khongconthamnam.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 How To Use Excel Hacks With Keyboard Shortcuts?
Excel Hacks (Table of Contents)
Start Your Free Excel Course
Excel functions, formula, charts, formatting creating excel dashboard & othersIntroduction to Excel Hacks How to Use Excel Hacks?
Here we discuss the list of most of Microsoft Excel’s significant shortcut buttons and main combinations with examples.
You can download this Excel Hacks Template here – Excel Hacks TemplateExample #1 – Use of Important Keyboard Shortcuts
1. Selection of Data
2. Column Width Size Adjustment
3. Insertion of Date or Time or Comments in Excel
In some scenarios, we need to enter today’s date & time; instead of looking into the calendar or time at the bottom, we can use the below-mentioned shortcut key.
For date: CTRL + ; or For time: SHIFT + CTRL + ;
4. Addition of a New Line in a Cell
Suppose you are entering address details, and you need to add multiple lines of data in the same cell; for that, you need to enter short cut key “Alt + Enter”, it will move the cursor down so that you can enter or type the text in the next line.
5. Addition or insertion of multiple columns or rows
6. Autosum the Selected Data Range
Suppose I have a numeric data range, so I want to do a sum up for that data range. To perform this task faster, you need to select the data range.
After pressing the “ALT key and Enter”, it will give the range’s total value.
7 Addition of Cell Border
Here we want to add a cell border across the data range.
After pressing on “Ctrl + Shift + &”, cell borders are automatically added.
8. Number Formatting
You can select a date range if you want a dollar sign displayed before each number.
9. Make a Copy of your Worksheet in the Same Workbook
Suppose you have a quarterly report in sheet 1 of a workbook, so you need to re-create it from scratch for the next quarter’s sales data, which is very difficult and time-consuming; you can use the “Move or Copy” option under the worksheet.
10. Freeze the Top Row
11. Addition of Filter for a Data Range
Suppose you want to filter data in a worksheet.Example #2 – Usage of Important Formulas
1. To Count Blank Cells in the Data Range with the help of the COUNTBLANK Formula
Here in the below-mentioned example, I want to count a blank cell in the data range (A2 to A7).
2. To Count Only Text Value in the Data Range with the help of COUNTA Formula
In the below-mentioned example, I want to count only a cell containing text values in the data range (A12 To A17); I can use the combination of the count formula, i.e., the COUNTA formula will count everything, including text & numeric value.
After using the COUNT formula, it will count only the numbers, i.e., = COUNTA (A2:A7)-COUNT (A2:A7). The difference between these two will result in an output value of 2.
3. To know the Formula Text or which formula you have used
If you know which formula is present in a cell, you can check it out with the help of the =FORMULATEXT(cell reference) formula. Here I have used cell A8 (as a cell reference).
After using the formula, the output is shown below.
4. To Pullout Only Decimal Values with the help of MOD & INT Function
I have a cell value of 98.23 in cell “A2” I want only the decimal portion in cell “B2”; to get this, I can use the formula MOD & INT function.
After using the formula, the output is shown below.Things to Remember
With the help of the symbols or arithmetic operators explained in the above examples in user or predefined Excel formulas, you can quickly perform various required calculations between numbers, cells, entire rows, and columns or ranges of cells.Recommended Articles
This is a guide to Excel Hacks. Here we discuss How to Use Excel Hacks with Excel shortcut keys, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –
You're reading How To Use Excel Hacks With Keyboard Shortcuts?
Update the detailed information about How To Use Excel Hacks With Keyboard Shortcuts? on the Khongconthamnam.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!