• Home
  • DSA
  • Concept
  • Interview
  • Tips&Tricks
  • Tutorial Videos
  • Home
  • DSA
  • Concept
  • Interview
  • Tips&Tricks
  • Tutorial Videos
  • #News
  • #APPS
  • #Events
    • #WWDC
    • #I/O
    • #Ignite
  • #Let’s Talk
  • #Advertise

MyCodeTips mycodetips-newlogocopy1

  • Home
  • DSA
  • Concept
  • Interview
  • Tips&Tricks
  • Tutorial Videos
ExcelTips

Formatting Cells in MS-EXCEL

Shortcut keys are easy to remember to operate and easy to remember. Because of simple keys its easy to handle formatting cells.

Shortcuts

Ctrl+N: Create a new workbook
Ctrl+O: Open an existing workbook
Ctrl+S: Save a workbook
F12: Open the Save As dialog box
Ctrl+W: Close a workbook
Ctrl+F4: Close Excel
F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
Shift+F11: Insert a new worksheet
Ctrl+Z: Undo an action
Ctrl+Y: Redo an action
Ctrl+F2: Switch to Print Preview
F1: Open the Help pane
Alt+Q: Go to the “Tell me what you want to do” box
F7: Check spelling
F9: Calculate all worksheets in all open workbooks
Shift+F9: Calculate active worksheets
Alt or F10: Turn key tips on or off
Ctrl+F1: Show or hide the ribbon
Ctrl+Shift+U: Expand or collapse the formula bar
Ctrl+F9: Minimize the workbook window
F11: Create a bar chart based on selected data (on a separate sheet)
Alt+F1: Create an embedded bar chart based on select data (same sheet)
Ctrl+F: Search in a spreadsheet, or use Find and Replace
Alt+F: Open the File tab menu
Alt+H: Go to the Home tab
Alt+N: Open the Insert tab
Alt+P: Go to the Page Layout tab
Alt+M: Go to the Formulas tab
Alt+A: Go to the Data tab
Alt+R: Go to the Review tab
Alt+W: Go to the View tab
Alt+X: Go to the Add-ins tab
Alt+Y: Go to the Help tab
Ctrl+Tab: Switch between open workbooks
Shift+F3: Insert a function
Alt+F8: Create, run, edit, or delete a macro
Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Worksheet or Cell

Left/Right Arrow: Move one cell to the left or right
Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row
Up/Down Arrow: Move one cell up or down
Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column
Tab: Go to the next cell
Shift+Tab: Go to the previous cell
Ctrl+End: Go to the most bottom right used cell
F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.
Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
Ctrl+Home: Move to the beginning of a worksheet
Page Up/Down: Move one screen up or down in a worksheet
Alt+Page Up/Down: Move one screen to the right or left in a worksheet
Ctrl+Page Up/Down: Move to the previous or next worksheet

Cell Formatting

Ctrl+B: Add or remove bold to the contents of a cell, selected data, or selected cell range
Ctrl+I: Add or remove italics to the contents of a cell, selected data, or selected cell range
Ctrl+U: Add or remove underline to the contents of a cell, selected data, or selected cell range
Alt+H+H: Select a fill color
Alt+H+B: Add a border
Ctrl+Shift+&: Apply outline border
Ctrl+Shift+_ (Underline): Remove outline border
Ctrl+9: Hide the selected rows
Ctrl+0: Hide the selected columns
Ctrl+1: Open the Format Cells dialog box
Ctrl+5: Apply or remove strikethrough
Ctrl+Shift+$: Apply currency format
Ctrl+Shift+%: Apply percent format


Besides Formatting Cells Also, Read

  • Essential MS Teams Keyboard Shortcuts
  • Best Tips And Tricks for Microsoft Teams
  • What’s New in Xcode 12!
  • How to Install Python on Windows

Cell Selecting

Shift+Left/Right Arrow: Extend the cell selection to the left or right
Shift+Space: Select the entire row
Ctrl+Space: Select the entire column
Ctrl+Shift+Space: Select the entire worksheet

Cell Editing

F2: Edit a cell
Shift+F2: Add or edit a cell comment
Ctrl+X: Cut contents of a cell, selected data, or selected cell range
Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range
Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or selected cell range
Ctrl+Alt+V: Open the Paste Special dialog box
Delete: Remove the contents of a cell, selected data, or selected cell range
Alt+Enter: Insert a hard return within a cell (while editing a cell)
F3: Paste a cell name (if cells are named in the worksheet)
Alt+H+D+C: Delete column
Esc: Cancel an entry in a cell or the formula bar
Enter: Complete an entry in a cell or the formula bar

Note: Formatting Cells, Some key combinations for shortcuts might not work or be changed, for the updated key shortcuts please follow Excel Help

Liked it? Take a second to support Ranjan on Patreon!
become a patron button
  • Click to share on Reddit (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • More
  • Click to share on Pocket (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
Written by Ranjan - 790 Views
Tags | easytips, quicktips
AUTHOR
Ranjan

Namaste, My name is Ranjan, I am a graduate from NIT Rourkela. This website is basically about of what i learnt from my years of experience as a software engineer on software development specifically on mobile application development, design patterns/architectures, its changing scenarios, security, troubleshooting, tools, tips&tricks and many more.

You Might Also Like

thumb-teams-for-beginners

OneDrive Guide for Beginners

July 16, 2021
troubleshooting-mac

Troubleshooting your Mac of SMC and PRAM/NVRAM

October 9, 2021
Valuable-Computer-Tips-for-Coders-1

Valuable Computer Tips for Coders

September 27, 2021
Next Post
Previous Post

Support us

mycodetips mycodetips
Follow us @ LinkedIn 2850+

Subscribe for updates

Join 8,213 other subscribers

Latest Posts

  • YT-Featured-solidprinciples
    SOLID Principles of Software Design
  • IOS 16 Features
    Latest features in IOS 16
  • r-language
    How can R language be used for data analysis?
  • wordpress-coding-blog
    Guide To WordPress Coding Standards
  • YT-Featured-Algorithm
    What is Algorithm?
  • Frameworks of IOS
    Frameworks of IOS – Part ( I )
  • NSFileManager or NSPathUtilities
    NSFileManager or NSPathUtilities in Objective-C
  • Passing data between view controllers in Objective-C
    Passing data between view controllers in Objective-C
  • structures-classes-enum
    Structures and Classes in swift !
  • control-system-swift
    Control Flow in Swift
whiteboard

Whiteboard(PRO)

whiteboard

Whiteboard(lite)

alphabets

Kids Alphabet

techlynk

Techlynk

techbyte

Do2Day

techbyte

Techbyte

  • #about
  • #myapps
  • #contact
  • #privacy
  • #Advertise
  • #Guestpost
  • #myQuestions

Android Android Studio API APP Programming Apps blogging CSS DATABASE dsa Features HTML HTML5 installation Interview Questions IOS iPhone javascript Mac objective-c OS Programming quicktips SDK SEO SQL swift Tips & Tricks Tools UI Web Wordpress Xcode

  • SOLID Principles of Software Design
  • Latest features in IOS 16
  • How can R language be used for data analysis?
  • Guide To WordPress Coding Standards
  • What is Algorithm?

©mycodetips.com