Explore the skills of Go To Special!

The function that allows you to detect all cells that contain special data like comments, formula, space, and data validation in your Excel list is the Go To Special function.

With this formula, you can select the cells with formulas at once and encrypt them with a formula; select the blank cells at once and highlight them; select the cells that contain numbers, text, or conditional formatting all together and execute the action you need.

This function is located in the Find&Select button in the Editing group in Home tab.

You can also press F5 (you might need to press the fn key as well) and choose Go To Special in the window that pops up.

Explore the skills of the Go To Special window and facilitate your work!

Let’s think about a scenario where we will fill the blanks in the Satış Bölgesi (Sales Region) column with the correct data like shown above.

First, we need to select the blank cells and then fill in the correct the quickest way possible!

How can we fill these cells easily without having to type into each of them one-by-one?

We will execute this action by using two features together.

Action Steps

  1. First, select the column that has the blank cells.
  2. The F5 shortcut (You might need to press the fn key) –> Go To Special
  3. Select Blanks in the window that pops open and click OK.

Then, we get the look below

You will see that the selected cells are gray and the cell on top is white. You can write into this cell directly. Which means that you don’t have to click to cell to be able to write. The reason why we focus on this is because the areas you want to work on are already selected, so no mouse click is needed. When you click a selected area with the mouse, it cancels the selection so you should be careful about it.

  1. We will write =G2 (the address of the cell right above it) through the keyboard directly. This way we get to say that we will use the data above to Excel. The most important point: Yes, we will write the data above but how is this formula work in the whole column?

    We move onto the fifth and last step for this action.
  2. For the =G2 action to work in all the selected areas of the column, we should press the CTRL and ENTER keys at the same time. After these steps, the Sales Region column will be filled completely.

    Other Go To Special Articles

    Take a look at this article to detect and encrypt the cells with formula by using the Go To Special window. And take a look at this article to learn which action to take to convert Blank Cells to a fixed text.

Excel Shortcuts1

It is possible for you to get to your destination the fastest way when you use shortcuts. But when you get support from the Navigation, it is probable that you will taking the fastest and traffic-free way.

We, as Office lecturers, offer you the most special and functional Excel shortcuts below for you to get to the result you want faster and in an optimum way.

Move Cells Between Pages

The Alt Shortcut:
It is enough to drag and leave while pressing the Alt key to move cells. This way, you can move cells to the page or location you want.

Create a New Line in the Cell

Alt & Enter Shortcut:
You can write texts one under the other or create articles in a cell in Excel just like in Word. It is enough to press the ALT and ENTER keys to move onto the next line in the cell.

Fastest Way to Create a Chart

Alt & F1 Shortcut:
It is the shortcut that allows you to create a chart the fastest way possible.
Select a field in the list you want to create a chart from and then press the Alt and F1 keys. A chart like the one below will be created quickly.

Navigate in the Page Fast

Ctrl & Arrow Keys:
You can quickly navigate in your list with the Ctrl & Arrow keys. You can reach the last full cell in your list. You can change the direction with the arrow key you want while pressing the Ctrl key.
*This is a general shortcut, you can even use it to navigate between texts while writing a text on your device.

Select Step by Step in the Page

Shift & Arrow Keys:
Allows you to select the cells in your list one by one. You can change your selection with the arrow key you want while pressing the Shift key.
*This is a general shortcut. You can even use it to select texts while writing a text on your device.

Bulk Selection in the Page

Ctrl & Shift & Arrow Keys:
You can select one by one with the Shift key, and if you want to make this action faster you can add the CTRL key. This way you can select way faster!
*This is a general shortcut. You can even use it to select texts while writing a text on your device.

Experience the easiness of adding and deleting a column/row quickly.

Ctrl & –  Shortcut and Ctrl & + Shortcut

You can delete columns/rows with the Ctrl & – keys,  and add columns/rows with the Ctrl & + keys.

Make the Cells Writable

F2 Shortcut:
We usually double-click the cell in order to write something in it. But it is enough to use the F2 shortcut instead of this.
*This is a general shortcut. You can even use it to change the name of a file on your device.

Enter Data to All Selected Cells

Select the cells you want to enter the data to.
Don’t click anything else once you are done selecting. Write the text you want directly.
Press the Ctrl & Enter keys for the text to be distributed to all cells.

The Fastest Way to Create a Table in Excel

Ctrl & L Shortcut:

Repeat the last action!

F4 Shortcut:
Allows you to repeat your last action.

For example, highlight the A1 cell with green and press the F4 key after clicking the B1 cell. You will see that the B1 cell will be highlighted with green as well! Since the previous action is repeated every time, you can just keep doing this with F4 forever!

It allows you to pin a cell while writing a formula. There are 4 different ways ($A$1 , A$1 , $A1, A1) to use this feature which is also known as Cell Reference Styles.

*Note: You might need to use the fn key (depending on your computer) to use the function keys with F like F1 and F2.

 

A combination of little clicks and keys can accomplish great things!

PowerPoint Shortcuts: The Most Frequently Used

You can have full control during your presentation with the PowerPoint shortcuts.

Start the Presentation: F5

You can start your presentation with the F5 shortcut.

Advance to the Next Slide: N

You can use the N key to advance to the next slide.

Return to the Previous Slide: P

You can use the P key to return to the previous slide.

You can use the N and P shortcuts (Next and Previous) to switch between slides.

Return to the First Slide: 1 + Enter

You might want to return to the first slide during the presentation. In this situation, you can return without having to return one-by-one. For that you need to press 1 and then Enter.

Start the Presentation from the Current Slide: Shift+ F5

You can start your presentation from the current slide without being lost between pages with the Shift F5 shortcut.

Display the Slide You Want: Slide Number + Enter

Use Slide page number and Enter to display the slide you want during the presentation. When you go 20 Enter you can go to the 20th slide.

Group Objects: Ctrl + G 

You can group the object for them to take actions together. Choose the object and then use the CTRL G shortcut for this action.

Blackboard: B 

You can use the screen as a blackboard during the presentation. You can write with a pen on the black background and make your presentation effective.

Whiteboard: W 

You can use the screen as a whiteboard during the presentation. You can write with a pen on the white background and make your presentation effective.

Erase all the Marks: E 

You can use this to erase all the marks done with the pen and cursor.

Return to the mouse cursor after you write with the pen: Ctrl + A 

You can use this shortcut to return to the mouse cursor after you write with the pen.

Hide the Pen or Cursor: Ctrl + H 

You can use this shortcut when you don’t want to see a pen or cursor in the screen.

Show hidden pen and cursors: Ctrl + U

Enables you to bring back the cursors you have hidden.

Save the Presentation As: F12

You can use this shortcut when you want to save your presentation as different formats like PDF or video, or when you want to change its location.

Now, you are ready you present faster with the PowerPoint shortcuts!