Excel Tricks & Tips

2019-02-12T12:17:00.001+05:30

Hi Friends,

After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day working on the most useful software as per my understanding of Microsoft Excel.

Expecting the same response from all of you.

Thanks
Hemant

Automatically numbering rows without error

2012-04-25T15:29:00.000+05:30

A simple solution to numbering a row even if we delete or add a rows in between the serial numbers.

Formula for numbering the row is “=Row()”

What this formula do Row formula allow us to know the row no. in which we are working.

The question raise how we can use this formula for no the rows?

Answer is simple if you had start the counting from row no 10 then the formula will be “=Row()-9” than the cell will reflect value 1.

Use and enjoy working.

Select/Replace/Find Similar Format Cells

2012-04-10T22:56:00.001+05:30

Some times people need to select similar format cells for analysis purpose or for editing the cells Now the question raise "How they can do this?" there is a simple process to this in excel same is defined here below. 1. Press "Ctrl + F" 2. Press "Options>>" 3. Click the arrow to the right of “Format” button (located at the right of the “Find what:” text box) 4. Select “Choose Format From Cell” (you can do it manually by using “Format” option instead) 5. Select the cell with the target format to select. The format is previewed at the right of “Find what:” text box 6. Press “Find All”. All the cells with the selected format are shown in the pane 7. Pick cells individually or press CTRL to select more than one to do the required action: replace, find, etc

one more important thing any one has to keep in mind while doing this is for using the find and replace command you have to select "clear find format".
Hope this tip will help you out some what.

By Numbers Excel 2003 v/s 2007

2012-03-26T22:41:00.000+05:30

Download link for "21 Underground Excel Tips"

2010-07-04T00:35:00.000+05:30

Hi all,

find the link of a good book for learning macros in Excel
http://www.4shared.com/office/bPq8kwot/21-underground-excel-tips-vol-.html
Regards

Microsoft Excel Bible 2007

2010-04-19T12:17:00.001+05:30

Dear All

Here is the link to download Microsoft Excel 2007 Bible

http://www.4shared.com/office/bPq8kwot/21-underground-excel-tips-vol-.html

Regards
Hemant Koranne

Just past your name on single click

2010-04-17T17:35:00.001+05:30

Here is the macro
Process is to use this is open your excel file click alt+F11 it will open one more window click on insert module & past this code in that module window. Replace your name with your own name
press save now close this window.
Sub yourname()
'
' yourname Macro
'
' Keyboard Shortcut: Ctrl+Shift+N
'
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
ActiveCell.FormulaR1C1 = "yourname"
With Selection
.HorizontalAlignment = xlCenter
End With

ActiveCell.Offset(1, 0).Range("A1").Select
End Sub

Now just press Ctrl+Shift+N and see the magic.

Enjoy
Hemant

Remove Non Printable Items from Text

2010-04-15T23:01:00.000+05:30

To Remove None Printable items from the cell containing text we just have to use a simple formula

=Clean(Cell number)

For Example In cell A1 you have text with some unwanted marks ahead of it just put a formula in Cell B1 =clean(A1) now you will see there are no non printable items are there they are gone now copy this and use past special and past value option your text is there without not printable items

Regards
Hemant

Multiple Row Filters in Same Sheet

2010-03-19T14:57:00.000+05:30

I was working on my data sheet and countered with one problem

I required filters in two row ranges on being specific I want the first filter to be placed for data range from Row no. 1 to 200 and the second one I want for Row no. 210 to 350.

So I try to do it with filter options that are available in Excel 2007 & Excel 2010 but not getting it but whenever I put the filter on second range first filter goes disappear so with the help of search on various options I got the answer for this problem. And it is here for your help also this we can do without macros

First Go to Insert ribbon in MS Excel 2007
Click on Table A "Create Table" Window will open Select the data range and Mark My Table has headers option
And repeat the same function for another range you will get the desired results.

Regards
Hemant

for more you can refer this book.

https://amzn.to/2SFxDv4

Opening A Link Workbook

2010-03-12T12:42:00.000+05:30

So many times we use another workbook data as a reference data by linking files to open those link or source files from the main file we could use following method

Go to Edit Menu open link and click on Open source

Or We can use Shortcut Key for this that is Ctrl+[

Regards
Hemant

Selecting cells that only contain Text in Microsoft Excel

2010-02-22T15:51:00.000+05:30

By selecting cells that only contain text, you can distinguish between cells containing different types of data, which allows you to delete, fill or lock cells by type.
Technique 1

Press F5, or choose Edit, Go To…;
In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

Technique 2 - Conditional
Formatting

Select the data area.
From the Format menu, select Conditional Formatting.
In Condition 1, select Formula Is.
In the Formula Box, enter the formula =Istext(A1).
Click Format..., choose any format from the Format Cells dialog box, and click OK.
Click OK.

Using keyboard shortcuts to open the Insert Function dialog box:

2010-02-10T16:08:00.000+05:30

Select an empty cell and press Shift+F3.
To open a Function Arguments dialog box:
Select a cell containing a formula and press Shift+F3.

To insert a new Formula into a cell using the Function Arguments dialog box:

1. Select an empty cell, and then type the = sign.
2. Type the formula name and press Ctrl+A.

To insert a formula by typing it while being guided by the formula syntax tooltip:

1. Select an empty cell, and then type the = sign followed by the formula name and a ( sign.
2. Press Ctrl+Shift+A (in Excel version 2003 the syntax appears immediately after step 1 above)

Change slash separator in date with period in Microsoft Excel

2010-02-09T16:18:00.000+05:30

Some times most people love to use period instead of / and would like to change the default setting for the date format, perform the following steps:

From Windows, choose Start, Settings, Control Panel, Regional Options.

Select the Date tab. In the Date separator box, change the slash (/) to a period (.).

Click Apply and OK

Moving to the last or first cell in the rang

2010-01-29T14:31:00.000+05:30

As you all know there are to ways that we could do any task in excel one with mouse and another with keyboard.

1. With Keyboard

• Vertically from top to bottom, press Ctrl+Down Arrow.
• Vertically from bottom to top, press Ctrl+Up Arrow.
• Horizontally from left to right, press Ctrl+Right Arrow.
• Horizontally from right to left, press Ctrl+Left Arrow.

1. With Mouse

Double-click one edge of the selected cell when the mouse image changes to four directional arrows.

Office 2007 Ribbon Hide

2010-01-28T18:53:00.000+05:30

Some times a user requirement of bigger view in excel to give it one thing we can do is hide the ribbon it is very simple to hide ribbon in excel all you have to do is Press Control + F1 and ribbon disappears and press again to reappear ribbon. You can also have it disappear so it will come back with a single click on any tab name. To do this, double click a tab name and the ribbon disappears. Single click a tab name and it reappears - click again on the tab or in the document, and it disappears. Repeat until you're tired of the magic! Double click or Control + F1 to go back to how it is.

Non Excel Tip : Invisible Folder

2010-01-25T18:17:00.000+05:30

Hi All,

Today I Thought to give you some thing different than excel so here it is an Invisible folder to create an invisible folder you have to do following steps
1. Create a folder on desktop by right clicking your mouse and select New than folder

2. now your folder named NEW Folder is Created.

3. Now the tricky part comes in Right Click the New Folder and rename it with clicking Space and than pressing Alt key and hit 016 from num side of Keyboard. now your folder without name is in-front of you.

4. Now the final step again right click the unnamed folder and go to Properties-->Customize-->Change Icon and select any blank space.

Here presenting Invisible Folder enjoy.

Regards

Hemant

Shortcut Keys At A Glance

2010-01-21T18:07:00.000+05:30

ctrl+shift+( Unhides any hidden rows within the selection.
ctrl+shift+) Unhides any hidden columns within the selection.
ctrl+shift+& Applies the outline border to the selected cells.
ctrl+shift_ Removes the outline border from the selected cells.
ctrl+shift+~ Applies the General number format.
ctrl+shift+$ Applies the Currency format with two decimal places (negative numbers in
parentheses).
ctrl+shift+% Applies the Percentage format with no decimal places.
ctrl+shift+^ Applies the Exponential number format with two decimal places.
ctrl+shift+# Applies the Date format with the day, month, and year.
ctrl+shift+@ Applies the Time format with the hour and minute, and am or pm.
ctrl+shift+! Applies the Number format with two decimal places, thousands separator,
and minus sign (–) for negative values.
ctrl+shift+* Selects the current region around the active cell (the data area enclosed by
blank rows and blank columns).
In a PivotTable, it selects the entire PivotTable report.
ctrl+shift+: Enters the current time.
ctrl+shift+” Copies the value from the cell above the active cell into the cell or the
Formula bar.
ctrl+shift+plus (+) Displays the Insert dialog box to insert blank cells.
ctrl+minus (–) Displays the Delete dialog box to delete the selected cells.
ctrl+; Enters the current date.
ctrl+` Alternates between displaying cell values and displaying formulas in the
worksheet.
ctrl+’ Copies a formula from the cell above the active cell into the cell or the
Formula bar.
ctrl+1 Displays the Format Cells dialog box.
ctrl+2 Applies or removes bold formatting.
ctrl+3 Applies or removes italic formatting.
ctrl+4 Applies or removes underlining.
ctrl+5 Applies or removes strikethrough.
ctrl+6 Alternates between hiding objects, displaying objects, and displaying
placeholders for objects.
ctrl+8 Displays or hides the outline symbols.
ctrl+9 Hides the selected rows.
ctrl+0 Hides the selected columns.
ctrl+a Selects the entire worksheet.
If the worksheet contains data, ctrl+a selects the current region. Pressing
ctrl+a a second time selects the current region and its summary rows.
Pressing ctrl+a a third time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula,
displays the Function Arguments dialog box.
ctrl+shift+a inserts the argument names and parentheses when the
insertion point is to the right of a function name in a formula.
ctrl+b Applies or removes bold formatting.
ctrl+c Copies the selected cells.
ctrl+c followed by another ctrl+c displays the clipboard.
ctrl+d Uses the Fill Down command to copy the contents and format of the
topmost cell of a selected range into the cells below.
ctrl+f Displays the Find and Replace dialog box, with the Find tab selected.
shift+f5 also displays this tab, while shift+f4 repeats the last Find action.
ctrl+shift+f opens the Format Cells dialog box with the Font tab selected.
ctrl+g Displays the Go To dialog box.
f5 also displays this dialog box.
ctrl+h Displays the Find and Replace dialog box, with the Replace tab selected.
ctrl+i Applies or removes italic formatting.
ctrl+k Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit
Hyperlink dialog box for selected existing hyperlinks.
ctrl+n Creates a new, blank workbook.
ctrl+o Displays the Open dialog box to open or find a file.
ctrl+shift+o selects all cells that contain comments.
ctrl+p Displays the Print dialog box.
ctrl+shift+p opens the Format Cells dialog box with the Font tab selected.
ctrl+r Uses the Fill Right command to copy the contents and format of the
leftmost cell of a selected range into the cells to the right.
ctrl+s Saves the active file with its current file name, location, and file format.
ctrl+t Displays the Create Table dialog box.
ctrl+u Applies or removes underlining.
ctrl+shift+u switches between expanding and collapsing of the Formula bar.
ctrl+v Inserts the contents of the clipboard at the insertion point and replaces any
selection. Available only after you have cut or copied an object, text, or cell
contents.
ctrl+w Closes the selected workbook window.
ctrl+x Cuts the selected cells.
ctrl+y Repeats the last command or action, if possible.
ctrl+z Uses the Undo command to reverse the last command or to delete the last
entry that you typed.
ctrl+shift+z uses the Undo or Redo command to reverse or restore the last
automatic correction when AutoCorrect Smart Tags are displayed.

Web Page from MS Excel

2010-01-20T16:12:00.000+05:30

If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel 97 can save them a lot of time by letting them open an HTML page in Excel directly from the Web.
The procedure is just a slight modification of the standard file-opening procedure:
1. Choose Open from the File menu.
2. In the File Name text box, type the URL of the Web file to open. Note: Be sure to include the prefix http://.
3. From the Files Of Type drop-down list, select HTML Documents (*.html, *.htm).
4. Click Open.
Excel opens HTML pages based on the HTML table structure of the page, so some Web design treatments may lead to some weird results in Excel. For pages that cleanly present data in a table format, however, this approach can be a real time-saver.

Hidden text in formula

2010-01-19T18:58:00.000+05:30

To put hidden tax in formula person have to use N() Function

Example : =100000+50000+N("Party X+Party Y")
Output := 150000

It is helpful when you want to display any information along with formula in single Cell.

Creat Backup of your Excel File

2010-01-18T17:38:00.000+05:30

To Create back up of your excel file automatically

Office Button ----> Save As --> Tools --> General Option

Or Click F12 and Than Tools --> General Option

And Mark Always Create Back up

Click Ok and replace the existing file with the new one.

How to apply different passwords or permissions to separate ranges in worksheets in Excel

2010-01-18T16:03:00.001+05:30

To apply group-level protection to a worksheet, follow these steps:
1.Start Excel, and then open a blank worksheet.
2.On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.

Note If you are running Excel 2007, click Allow Users to Edit Ranges in the Changes group on the Review menu.
3.In the Allow Users to Edit Ranges dialog box, click New.
4.In the New Range dialog box, click Collapse Dialog, select the range B2:B6, and then click Collapse Dialog again.
5.In the Range password box, type rangeone, and then click OK twice. When prompted, retype the password.
6.Repeat steps 3 through 5, selecting the range D2:D6 and typing rangetwo as the password for that range.
7.In the Allow Users to Edit Ranges dialog box, click Permissions, and then click Add in the Permissions for Range2 dialog box.
8.In the Select Users, Computers, or Groups dialog box, type Everyone.
9.Click OK in the Select Users, Computers, or Groups dialog box, and then click OK in the Permissions for Range2 dialog box.
10.In the Allow Users to Edit Ranges dialog box, click Protect sheet, type ranger in the Password to unprotect sheet box, and then click OK twice. When prompted, retype the password.
11.Select cell B3, and then start to type Dataone. A password is still required. Click Cancel in the Unlock Range dialog box.
12.Select cell D3, and then type Datatwo.

When you apply different passwords to separate ranges in this way, a range that has been unlocked remains unlocked until the workbook is closed. When you unlock another range, you do not relock the first range. Likewise, when you save a worksheet, you do not relock a range.

You can use existing range names to identify cells that are to be protected with passwords, but if you do, Excel converts any relative references in the existing name definitions to absolute references. Because this may not give you the results you intended, it is preferable to use the Collapse Dialog button to select the cells, as described earlier in this article.

Inserting Current Date & Time

2010-01-18T15:39:00.000+05:30

Here is the shortcut for entering Current Date in Selected Cell

=Ctrl+

And to Insert Current Time it will be

=Ctrl+Shift++

Tips to look more profession in Excel

2010-01-16T14:54:00.002+05:30

Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For example, labels and values are often underlined to distinguish them from the rest of the data. To access these formats, click on the cell you want formatted and press [Ctrl]1. Click on the Font tab and then click on the drop-down arrow of the Underline combo box. This box offers four different types of line formatting. While the Single and Double format are appropriate for text labels, they are not appropriate for indicating totals and subtotals. For Totals, you should choose the Double Accounting format; for Subtotals, choose the Single Accounting format.

Another way you can make your worksheets look more professional is to remove zero values. For example, you've just copied a formula down a column, and now you have blocks of cells containing 0.00 or 0.00%. You could go back and delete the formulas from those particular cells, but an easier method would be to change the worksheet to avoid displaying or printing the zero values. To do so, follow these steps:

Go to Tools | Options.
Click the View tab.
Under the Window Options section, clear the Zero Values check box.
Click OK.

10 TIPS TO WORK FAST

2010-01-16T14:46:00.000+05:30

#1: Exploit defined names

Defined names aren't just for ranges. You can use a defined name to define a constant value, such as a discount amount. Use the feature as you normally would, entering the literal value or expression that evaluates to the desired value into the named cell. For instance, select a cell and choose Name from the Insert menu. Then, select Define. Enter the descriptive name Discount and click OK. Now, in the same cell, enter the actual discount amount, say 3 percent (just enter .03). Now, you can use the defined name, Discount, in your formulas instead of entering the literal value .03. For instance, Excel would use .03 for Discount when evaluating the following formula:

=TotalPrice - (TotalPrice * Discount)

This quick tip has two benefits: It makes updating much simpler, as you can quickly change the value in Discount and Excel will automatically update all dependent formulas. And it eliminates data entry errors.

#2: Quick copy to noncontiguous cells

Copying data or a formula is simple. You just drag the source cell's fill handle and Excel copies the data or formula from the source cell to the cells you select using the fill handle. But copying isn't always a nice, neat, contiguous package. Sometimes you need to copy data or a formula to a series of noncontiguous cells. You could paste the source data into each individual cell, but that's the hard way. Instead, you can copy data into a noncontiguous block.

First, copy the source data. Then, hold down the Ctrl key while you click each cell in the noncontiguous destination range. Once you've highlighted each target cell, press Ctrl+V, and Excel will copy the source data into each of the highlighted cells. Formulas copied this way obey referencing rules, in regard to absolute and relative addresses.

An alternate method is to right-click in the cell that contains data you want to copy and choose Copy from the resulting submenu. Then, right-click a destination cell and choose Paste. At this point, the source cell is still highlighted, which means you can copy the contents again. Right-click another destination cell and choose Paste. Continuing selecting destination cells until you've completed the copy task. Press Esc to clear the selection of the source cell.

#3: Customize defaults

Excel uses template files to control default settings in new workbooks and sheets. For most of us, the settings are adequate. However, if you find yourself resetting the same defaults for each new workbook or sheet, consider changing the defaults permanently.

To change default settings for a workbook, open Book.xlt, make changes, and then save the file. Don't change the file's name; you're just updating it. (It's a good idea to create a copy of the original Book.xlt so you can revert to Excel's original settings if necessary. Name the copy BookOriginalSettings.xlt or something similarly descriptive.) After changing Book.xlt, all new workbooks will use the custom settings you applied. To change a sheet's default settings, open Sheet.xlt, make the necessary changes, and save it.

If you don't have one or both files, simply create your own. Just be sure to save them in Excel's XLStart folder (\Program Files\Microsoft Office\XLStart).

#4: Enter repetitive data quickly

Tip #2 shows you how to copy existing data into noncontiguous cells. You can also use this technique to enter data into a series of noncontiguous cells. Hold down the Ctrl key and click all the cells into which you want to enter data. Then, type the text you want to enter and press Ctrl+Enter. Excel will enter the typed text into all of the cells in the noncontiguous selection.

#5: Create custom lists

Most of us work with sets of data that seem to repeat themselves throughout our projects. That means we can enter the same values in numerous spots. If you frequently enter the same dataset, consider creating a custom list. To do so, choose Options from the Tools menu and then click the Custom Lists tab. In the List Entries control, enter each item in the list, one entry per line, in the order in which you want it to appear. When you've completed the list, click Add. Excel will copy the list to the Custom Lists control. Click OK to close the Options dialog. To enter the list, select a cell and enter any name in the list. Then use the fill handle to complete the list.

If you want a partial list, enter the item you want to begin with and then pull down the fill handle. Excel will fill in the remaining names.

If the list already exists in the sheet, you don't have to retype it to create a custom list. Simply select the list before choosing Options from the Tools menu. Then, click Import on the Custom Lists tab.

#6: Customize movement

By default, the cell pointer moves down when you press Enter. Selecting the cell immediately below the current one won't always be what you need. For instance, some people enter data from column to column. You could press the Right Arrow key instead of Enter, but out of habit, most of us reach for Enter. Even if you can retrain yourself (or users) to use the arrow keys, they're far enough away from the main keys to slow down data entry.

Fortunately, you can change the cell pointer's default direction. Chose Options from the Tools menu and then click the Edit tab. Select the Move Selection After Enter check box (if necessary) and then choose a direction from the option's drop-down list. For instance, to move from column to column, you might choose Right instead of Down.

While entering data, you can temporarily force the cell pointer to move in the opposite direction by holding down the Shift key while you press Enter.

#7: Hide everything but the working area

You usually hide a column or row to conceal or protect data and formulas. You can also hide unused regions of a sheet to keep users from exploiting unused areas or to help keep them on task by not allowing them to wander. By hiding unused rows and columns, you present a sheet that focuses on just the work area.

To hide unused rows, select the row beneath the sheet's last row. (Select the row header to select the entire row.) Next, press Ctrl+Shift+Down Arrow to select every row between the selected row and the bottom of the sheet. Then, choose Row from the Format menu and select Hide. Repeat this process to hide unused columns, only select the column header in the first empty column. Press Ctrl+Shift+Right Arrow and then choose Column from the Format menu instead of Row.

Before you hide anything, make sure you don't inadvertently hide an obscure area by pressing Ctrl+End to find the last cell in the sheet's used range. Unhide the rows and columns by selecting the entire sheet. Then, select Row or Column from the Format menu, and choose Unhide.

#8: View formulas, or not, quickly

You probably know that you can view all the formulas in a sheet by choosing Options from the Tools menu and selecting Formulas on the View tab. Doing so displays formulas instead of their evaluated results. But there's a quicker way. Press Ctrl+~ (the tilde character to the left of the number 1 on your keyboard). The keyboard combination toggles between formulas and normal view. When you're finished viewing the formulas, simply press Ctrl+~ again to return to normal view.

#9: Identify printed sheets

Printing a sheet is a common task. Some users find it useful to print the name of the workbook in the header or footer. In Excel 2003, you can accomplish this by choosing Page Setup from the File menu and clicking the Header/Footer tab. Then, choose the appropriate item from the Header control's drop-down list. Versions prior to 2003 can use the following VBA procedure to print the full file's pathname:

Sub FormatHeader()
With ThisWorkbook
ThisWorkbook.Worksheets(sheetname)PageSetup.LeftHeader = .FullName
End With
End Sub

where sheetname is the sheet's name as a string value. To make the procedure more dynamic, use ActiveSheet.Name instead. That way you can run it against any sheet in the workbook.

#10: Speed up calculation time

How, when, and what Excel calculates is a huge subject. In general, cell references and calculation operations are the main performance vampires. Reasonable formulas and even lots of data don't usually slow things down. Complex formulas and repetitive references are the real culprits. Here are a few basic guidelines that should help you avoid calculation bottlenecks:

Avoid complex and array formulas. Use more rows and columns to store intermediate values and use fewer complex calculations.
Reduce the number of references in each formula to the bare minimum. Copied formulas are notorious for repeating references and calculations. Move repeated calculations to a cell and reference that cell in the original formula. (See Tip #1 for an alternate suggestion.)
Always use the most efficient function possible: Sort data before performing lookups; minimize the number of cells in SUM and SUMIF; replace a slow array with a user-defined function, and so on.
Avoid volatile functions if possible. Excel recalculates these functions with each recalculation, even if nothing has changed. Too many volatile functions (RAND(), NOW(), TODAY(), and so on) can slow things down.

Excel Shotcuts

2010-01-16T14:32:00.000+05:30

Navigating in Excel Shortcut

Switch between Worksheets CTRL-PageUp/CTRL-PageDown

Switch between Workbooks CTRL-Tab

Move one character up, down, left, or right. Arrow keys

Go to end of a contiguous range CTRL-Arrow Keys

Select a cell range SHIFT+Arrow keys

Highlight a contiguous range SHIFT-CTRL-Arrow Keys

Select entire worksheet CTRL+A

Move to the beginning of the line. HOME

Go To F5

Move a Sheet/Copy a Sheet Alt-E-M

Change Zoom Sizing Alt-V-Z

Entering and editing data Shortcut

Complete a cell entry and select…

...the cell below. ENTER

...the previous cell above. SHIFT+ENTER

...the next cell to the right. TAB

...the previous cell to the left. SHIFT+TAB

Delete cell and then get inside the cell BACKSPACE

Delete cell/selection. DELETE

Edit inside a cell (edit cell mode) F2

Once inside edit cell mode (F2)…

...Start a new line in the same cell. ALT+ENTER

...Highlight individual characters within cells SHIFT+Arrow keys

...Highlight contiguous string within cells SHIFT+CTRL+Arrow keys

...Delete the preceding character. BACKSPACE

...Delete the character to the right of the insertion point. DELETE

...Cancel a cell entry. ESC

Spell Check. F7

Insert a comment. SHIFT+F2

Fill down. CTRL+D

Fill to the right. CTRL+R

Undo the last action. CTRL+Z

Redo the last action. F4 or CTRL+Y

Hiding / Unhiding Rows and Columns Shortcut

Hide the selected rows. CTRL+9

Unhide any hidden rows within the selection. CTRL+SHIFT+( (opening parenthesis)

Hide the selected columns. CTRL+0 (zero)

Unhide any hidden columns within the selection. CTRL+SHIFT+) (closing parenthesis)

Selecting, grouping, inserting, and deleting cells Shortcut

Highlight Entire Row SHIFT+SPACEBAR

Highlight Entire Column CTRL+SPACEBAR

Group Rows or Columns SHIFT+ALT+RIGHT ARROW KEY

Ungroup Rows or Columns SHIFT+ALT+LEFT ARROW KEY

Clear the contents of the selected cells. DELETE

Delete the selected cells. CTRL+MINUS SIGN

Insert blank cells. CTRL+SHIFT+PLUS SIGN