CTRL, ALT,  Function Keys and the Mouse in Excel

Excel reporting and databases                              Excel Examples

 

Excel tips on functions and formulas

 

Excel Reports Sitemap

 

Excel Tutorial

 

 

 

 

Excel database 101

 

Excel external data

 

Excel data analysis

 

Excel Reporting

 

Tips and help ion Excel

 

 

 

Excel Functions and Formulas

 

Excel Macros and VBA

Lesson 27: CTRL, ALT,  Function Keys and the Mouse in Excel

On your keyboard you see some function keys at the top (F1, F2...). Some of these keys perform interesting functionalities in Excel. Other interesting functionalities in Excel are activated when you hold the CTRL or the ALT key while pressing on some letters. The right click of the mouse also gives access to nice functionalities.

Here are these shortcuts by order of importance. I use the ones at the top of the list every day.

CTRL/x cuts (and deletes) the value or formula in a cell or set of cells to be pasted somewhere else.

CTRL/c picks up the value or formula of a cell or a set of cells to be pasted somewhere else.

CTRL/v pastes (I call it CTRL/Velcro)

CTRL/f to find a value in a row a column (that you have selected) or a sheet. To find a value in the whole workbook select all sheets (see how below).

CTRL/h to find and replace.

ALT/Enter to force a line break within a cell.

The F4 key allows you to add dollar signs to addresses AUTOMATICALLY. See chapter 11 on absolute and relative references.

CTRL/a selects all the cells of a sheet. You can also use your mouse and click on the small gray square between the " 1" and the " A" at the top left corner of the sheet.

CTRL/Arrow Down will send you to the last cell in a column

Shift/CTRL/Arrow Down will select all the cells from where you are in the column to the last non-empty cell of the column

Apply the same logic to Up arrow, the Right arrow and the Left arrow

CTRL/Enter: Select many cells and then enter a value in the formula bar (just above the sheet on your screen). Hold the CTRL key and click Enter. The same value is entered in all the cells.

To replace a word just click on it and start writing its replacement. No need to delete it.

Many different contextual menus are available when you use the right button of the mouse. Right click on a chart, a cell, the columns and rows headings, a text box....right click on everything and you will discover wonders.

When you select a cell, many cells, a row or a column you can right click on the mouse and discover the VERY important " Clear Contents" . This functionality doesn't make the selection disappear like the " Delete" functionality it just clears the contents of the selected item. When you start working with Excel databases and automated reports using SUMPRODUCT it is vital that you use " Clear Contents" instead of " Delete" .

To select 2 or more  cells that are not contiguous click on the first one hold the CTRL key down and select the others.

To select many contiguous cells click on the first one hold the SHIFT key and click on the last one.

To select 2 or more  sheets click on the tab of the first one hold the CTRL key down and select the others. The word [Group] appears beside the workbook name at the top of your screen. To deactivate the grouping click on any single tab. When a group of sheets is selected anything you enter in cell A1 of the active sheet (for example) is also entered on the other sheets.

To select all the sheets click on the tab of the first one hold the SHIFT  key and click on the tab of the last one.

If  you have deactivated the calculation "Tools/Options/Calculation/Manual" and you want a sheet to be recalculated use the F9 key.


There are  five sections in this website

Section 1: About Databases: 4 Lessons
In this section we review the basic notions on databases and evaluate Excel as a database. You will then see how Excel can be used downstream from most centralized databases and data management programs. Finally we will discuss the "upgrade" from Excel to Access..
Section 2: Excel and External Data: 7 Lessons
There are many ways to get data into your Excel Workbooks and there are many ways to easily extract data from all the databases in your organization and the Internet. This section is centered on querying data
Section
3:
Analyzing Data with Excel: 8 Lessons
Once you have the data in the right formats within your Excel workbook it is time to use the powerful analytical tools of Excel including the database functionalities (sort, filter, subtotals), the integrated calculator, the comparative analysis tools and the mysterious and not so complicated pivot tables. 
Section 4: Reporting with Excel: 7 Lessons
The report is a communication tool and you can not accept to compromise on its presentation. Excel is the best reporting tool allowing you to easily develop popular dashboards and to share these reports with multiple colleagues.
Section 5: Other Functionalities in Excel: 3 Lessons
In this fifth section you will review the useful CTRL and ALT keystrokes, the conditional formatting, the drop-down lists and other interesting functionalities.

 

 

   

 

Excel fonctions et formules

Database 101   Excel and External Data   Analyzing Data with Excel   Reporting with Excel   Other Functionalities
Email   
Tutorials