[PDF] 50 time-saving keyboard shortcuts in Excel for Windows

50 time-saving keyboard shortcuts in Excel for Windows

shortcuts in Excel for Windows Navigate in cells Move one screen down in a worksheet Move to the beginning of a worksheet Page Ctrl + Home Down Move one screen to the right in a worksheet Move to the next sheet in a workbook Alt + Page Ctrl + Down Extend the selection of cells to the last used cell on the worksheet (lower-right corner)

LES RACCOURCIS CLAVIER Excel - Caride Formation

Raccourcis clavier et les touches de fonction Excel pour Windows Pour un raccourci clavier où vous devez appuyer simultanément sur plusieurs touches, la rubrique sépare lesdites touches par un signe plus (+) Quant à un raccourci où vous devez appuyer sur une touche puis

Liste des principaux raccourcis clavier du tableur Excel

F1 Ouvre l’aide intégrée d’Excel F7 Lance le correcteur d’orthographe F9 Recalcule le contenu du classeur en cours F10 Afficher les raccourcis clavier du ruban F11 Créer une feuille de graphique Contrôle + F1 Masquer ou afficher le ruban Echappement Fermer une boite de dialogue sans la valider

Fiche raccourcis Excel - Pearson

de formule avec la touche de raccourci F9 • Sélectionnez la partie que vous voulez évaluer dans la barre de formule FFiche raccourcis Excel indd 1iche raccourcis Excel indd 1 007/02/13 11:227/02/13 11:22

LES RACCOURCIS CLAVIER DEXCEL - Formabox

LES RACCOURCIS CLAVIER D'EXCEL LA GESTION DES FICHIERS Ctrl + N Créer un nouveau classeur Ctrl + O Ouvrir un classeur existant Ctrl + S Enregistrer le classeur actif Ctrl + W Fermer le classeur actif LES ESSENTIELLES Ctrl + P Ouvrir la boîte de dialogue d'impression Ctrl + Z Annuler la dernière opération

Free

Title: RaccourcisclavierExcel Created Date: 2/3/2006 3:52:37 PM

Raccourcis de Windows

Raccourcis Excel Raccourcis Word QWERTY Raccourci clavier Explorateur Windows Touche Ctrl Liens externe Raccourcis claviers sous Windows Vista PC Astuces - Les principaux raccourcis clavier pour Windows Microsoft - Liste des raccourcis clavier disponibles dans Windows XP Notes et références de l'article 1

Free

˘ ˇ ˆ ˙ ˝˝ ˙ ˛˘ ˚˙ ˝ ˝ ˝ ˇ ˜ ˇ˙˙ " ˇ # $ ˙ ˙ Title: RaccourcisclavierWord Created Date: 2/2/2006 4:17:57 PM

File management Search and replace Keyboard shortcuts for Windows

General Ctrl+Shift+P, F1 Show Command Palette Ctrl+P Quick Open, Go to File Ctrl+Shift+N New window/instance Ctrl+Shift+W Close window/instance

[PDF] pdf raccourcis clavier windows 7

[PDF] raccourci clavier windows 8.1 pdf

[PDF] excel 2013 pour les nuls pdf

[PDF] office 2010 pour les nuls

[PDF] ferragus balzac commentaire

[PDF] word 2010 pour les nuls pdf gratuit

[PDF] mission indigo 3e correction

[PDF] mission indigo 3ème corrigés pdf

[PDF] raccourcis clavier excel 2010 pdf

[PDF] mission indigo 3ème en ligne

[PDF] programmation vba pour excel 2010

[PDF] 2013 et 2016 pour les nuls

[PDF] mission indigo 3ème pdf

[PDF] mission indigo 4ème

[PDF] mission indigo 3ème corrigés

For more tips, videos, help, and training, visit

aka.ms/excelhelpcenter

50 time-saving keyboard

shortcuts in Excel for Windows

Navigate in cells

Move one screen down in a worksheet. Move to the beginning of a worksheet.

Page DownHome+Ctrl

Move one screen to the right in

a worksheet.

Move to the next sheet in a

workbook.+AltPage

DownPage

Down+Ctrl

Extend the selection of cells to the

last used cell on the worksheet (lower-right corner).

Move to the last cell on a worksheet,

to the lowest used row of the rightmost used column.

Shift+End+Ctrl

End+Ctrl

Move one screen to the left in a

worksheet.

Move one screen up in a worksheet.

+AltPage Up

Page Up

Move to the previous sheet

in a workbook. +CtrlPage Up

Move to the edge of the current

data region in a worksheet.

Move one cell to the right in a worksheet. Or,

in a protected worksheet, move between unlocked cells. +CtrlArrow Key Tab

Make selections and perform actions

Start a new line in the same cell. Enter+AltFill the selected cell range with the current entry. Enter+Ctrl

Extend the selection of cells

by one cell.

Select the entire

worksheet. +ShiftArrow KeyorA+Ctrl+CtrlShiftSpacebar+

Select an entire column in a worksheet. CtrlSpacebar+Select an entire row in a worksheet. Shift+Spacebar

Repeatthe last command or action. Ctrl+YUndo the last action. Ctrl+Z

Format in cells

Display the Create Table

dialog box. L+CtrlT+Ctrlor

Format a cell by opening the Format

Cells dialog box.

Edit the active cell and put the insertion

point at the end of its contents. 1+CtrlF2 Add or edit a cell comment. F2+ShiftOpen the Insert dialog box to insert blank cells.+Shift+CtrlPlus (+)

Open the Delete dialogbox to

delete selected cells. +CtrlMinus (-) Enter the current time. Colon (:)+Shift+CtrlEnter the current date. +CtrlSemi-colon (;)

Switch between displaying cell values

or formulas in the worksheet. Grave accent (`) +CtrlOpen the Paste Special dialog box. +Ctrl+AltV

Use the Fill Down command to copy the

contents and format of the topmost cell of a selected range into the cells below. +CtrlD

Use the Fill Right command to copy the

contents and format of the leftmost cell of a selected range into the cells to the right. +CtrlR

Apply the Percentage format

with no decimal places. Percent (%)+Shift+CtrlApply the Scientific number format with two decimal places.+Shift+CtrlCaret

Apply the Date format with

the day, month, and year.

Number

sign (#)+Shift+CtrlApply the Time format with the hour and minute, and AM or PM. +Shift+CtrlAt sign

Apply the Number format

with two decimal places, thousands separator, and minus sign (-) for negative values.

Exclamation

point (!)+Shift+CtrlCreate or edit a hyperlink. +CtrlK

Check spelling in the active worksheet or

selected range.F7Display the Quick Analysis options for selected cells that contain data. +CtrlQ

Undo.Z+CtrlClose a spreadsheet.W+Ctrl

Cut.X+CtrlOpen a spreadsheet.O+Ctrl

Delete column.H,D, then C+AltSave a spreadsheet.S+Ctrl

Go to Formula tab.M+AltCopy.C+Ctrl

Paste.V+Ctrl

Frequently used shortcuts

Go to Home tab.Alt+H

Move to the previous cell in a

worksheet or the previous option in a dialog box. +ShiftTab > Autresquestions ? > More questions ?

Call us to 0848 711 266

quotesdbs_dbs2.pdfusesText_2