The Quick Find Next (Repeat Search without Dialogue Box) – Excel Tip

 

In order to search a text in an Excel File  we need to invoke the “Find and Replace” tool in Microsoft Excel by hitting [Ctrl]+[F] as shown in figure 1.1 below…

Figure 1.1

To search the next occurrence of the text one has to again invoke the same “Find and Replace” dialogue box.

However, not many of us really know that Excel provides a quick way to repeat the search without invoking the Find dialogue. The quick Find Next works as stepped out below…

1. Invoke the “Find and Replace” dialogue box by pressing [Ctrl]+[F] key combination
2. Type the text that you intend to search and click “Find Next” button in “Find and Replace” dialogue box.
3. Press [Esc] key to close the “Find and Replace” dialogue box.
4. Press [Shift] + [F4] key combination to repeat the search without invoking “Find and Replace” dialogue.

I hope you found the tip useful and thank you for reading.

MS Excel Navigation Shortcuts

There are several navigational shortcuts that can help one expedite the work by allowing quick Navigation within worksheet and across worksheets/workbook in Microsoft Excel. Below tables lists such know short-cuts. Some shortcuts are likely to be specific to a particular version of Microsoft Excel and however, in general should be applicable to all.

Task / Objective	Shortcut / Key Sequence
Jump to Cell A1	[Ctrl]+[Home]
Jump to the last cell in the worksheet that contains Data.	[Ctrl]+[End]
Jump to Next Sheet (To the right of current sheet)	[Ctrl]+[PgDn]
Jump to Previous Sheet (To the left of current sheet)	[Ctrl]+[PgUp]
Go To a Cell	[F5]
Toggle between open workbooks. More than one workbook (excel file) must be open	Ctrl + TAB
Hide Column	[Ctrl] + [0]
Unhide Column	[Ctrl] + [Shift] + [0]
Hide Row	[Ctrl] + [9]
Unhide Row	[Ctrl] + [Shift + [9]
Show/Hide Chart	[Ctrl] + [6]
Select Multiple Cells (Hold [Ctrl] key while clicking cell. You can click random cells in the worksheet.)	[Ctrl] + [Click]
Select Range of Cells (Hold Shift Key while selecting cells to select a range)	[Shift] + [Click] or [Shift] + {Arrow Keys}
Select current data block (cell containing data including and adjacent to current selection)	[Ctrl] + [*] or [Ctrl] + [Shift] + [8]

I hope you found the information useful and Thank you for reading.

MS Excel Shortcuts

You may want to keep below set of key sequences handy as it can definitely improve your productivity while working with Excel.

Task	Key Sequence
Hide Column	[Ctrl] + [0]
Unhide Column	[Ctrl] + [Shift] + [0]
Hide Row	[Ctrl] + [9]
Unhide Row	[Ctrl] + [Shift] + [9]
Refresh	[Ctrl] + [6]
Strike Out	[Ctrl] + [5]
Underline	[Ctrl] + [4]
Italic	[Ctrl] + [3]
Bold	[Ctrl] + [2]
Format Cell Dialog	[Ctrl] + [1]
Change Relative Cell Ref to Absolute ref. (Toggle Key)	[F4]
Edit Current Cell	[F2]
vzGo To a Cell	[F5]
Toggle between Show Formula/Normal Mode in whole worksheet (Toggle Key)	[Ctrl] + [`]
Close Current Workbook	[Ctrl] + [w]
Copy Contents of Cell to Left	[Ctrl] + [R]
Create Table and set filters	[Ctrl] + [L] Or [Ctrl] + [T]
Insert Hyperlink Dialog	[Ctrl] + [K]
Current Date	[Ctrl] + [;]
Current Time	[Ctrl] + [:]
Copy Contents of Cell above current selection	[Ctrl] + [']
New Workbook	[Ctrl] + [N]
Delete Selected Cell	[Ctrl] + [-]
Insert Blank Cell	[Ctrl] + [=]
Auto Sum	Alt + [=]
Complete Formula with parenthesis and parameters	[Ctrl] + [Shift] + [A]
Toggle between open workbooks	[Ctrl] + [TAB]
Open Worksheet to left of current worksheet	[Ctrl] + [PgUP]
Open Worksheet to right of current worksheet	[Ctrl] + [PgDn]
Box the Current Selection	[Ctrl] + [Shift] + [7] or [Ctrl] + [&]

I hope you found the information useful and Thank you for reading.