Excel Formatting Shortcuts
If you have closely followed the previous parts of this tutorial, you already know most of the Excel formatting shortcuts. The table below provides a summary.
Shortcut Format
Ctrl+Shift+~ General format
Ctrl+Shift+! Number format with a thousand separators and two decimal places.
Ctrl+Shift+$ Currency format with two decimal places and negative numbers displayed in parentheses
Ctrl+Shift+% Percentage format with no decimal places
Ctrl+Shift+^ Scientific notation format with two decimal places
Ctrl+Shift+# Date format (dd-mmm-yy)
Ctrl+Shift+@ Time format (hh: mm AM/PM)
Excel opens with all the cells looking the same. Things can get hard to understand if you have a lot of them. Changing Excel's look is as simple as changing the font and size parameters to modify the appearance of your written work. The key points become more apparent, and the material becomes more accessible.
Excel also lets you choose whether the numbers are money ($) or percentages (%). Then, it will know just what to display to them. After these easy changes, your Excel file will look better and be easier for everyone to understand.
How to Change the Font?
Step 1: Select the cell
Click on the cell or drag to select multiple cells where you want to change the font.
Select the cell Step 2: Click the Font dropdown arrow
To access the Font menu, go to the Home tab and click the arrow near the dropdown.
Click the Font dropdown arrow Step 3: Select the desired font
You can pick one from the list of available fonts.
Select the desired fontStep 4: The font will change
The text in the chosen cells will immediately change to reflect the new font style after you've picked a font.
How to Change the Font Size?
Step 1: Select the cells
Select the cell to change the font size of it.
Select the cells Step 2: Open Font Size dropdown
Click the dropdown arrow next to the Font Size command on the Home tab.
Open Font Size dropdownStep 3: Select the font size
Select a font size from the list of available options.
Select the font sizeStep 4: Once applied, the text in the selected cells will be resized to match the font size.
Note: You may adjust the font size using the keyboard keys "Increase" and "Decrease" or by navigating the controls on your keyboard.
How to Change the Font Color?
Step 1: Select the cells
Click on one cell or drag to select multiple cells.
Select the cellsStep 2: Open the Font Color dropdown on Home
Simply click the down arrow next to Font Colour on the Home to change the font colour.
Open the Font Color dropdown on HomeStep 3: Select the font color
Pick a colour from the spectrum that works for you.
Select the font colorStep 4: The selected font colour will changed
The text in the chosen cells will be changed to match the new colour of the font.
How to Use the Bold, Italic, and Underline Commands?
Step 1: Select the cells
Press and hold or drag to choose several cells for formatting.
Select the cellsStep 2: Select Bold, Italic, or Underline from the Home
From the Home menu, choose Bold (B), Italic (I), or Underline (U). This will change the style of the text you have chosen.
Select Bold, Italic, or Underline from the HomeStep 3: The selected style will be applied
The highlighted, italicised, or bolded text will be the one you choose.
Note: Pressing Ctrl+B, Ctrl+I, and Ctrl+U on the keyboard will correspondingly bold, italicise, and underline the chosen text.
How to use Text Alignment?
Numbers will be aligned to the bottom-right of a cell and text to the bottom-left of a cell in your worksheet by default. You may arrange cell information to make it simpler to read.
Step 1: Select the cells
Click or drag to select multiple cells to change text alignment.
Select the cells Step 2: Go to the Home, find alignment options
To access the Home tab in Excel, go to the ribbon. Various alignment choices may be found in the "Alignment" category.
Step 3: Choose from left, centre, or right alignment options
Choose one of the three horizontal alignment commands from the Home tab: left, centre, or right.
Go to the Home, find alignment optionsStep 4: The text will realign
Text in the selected cells will be aligned after you make your selection.
How To Add a Border in Excel?
Step 1: Select the cells
To add a border, click on the cell or groups of cells that you want to border.
Select the cellsStep 2: Click the Borders on the Home
On the Excel menu, go to the Home tab. The "Borders" button is in the "Font" group. It looks like a grid with borders.
Click the Borders on the HomeStep 3: Select the border style
From the dropdown box, pick the border style you want to use. Some options are: There are no borders, all borders, outside borders, thick box borders, and more borders.
Select the border styleStep 4: Apply Border
Click on the border style option to apply it to the selected cells.
How To Add a Fill Color?
Step 1: Select the cells
Click on the cell where you want to fill in the colour.
Select the cells Step 2: Click "paint bucket" in the "Font" group
On the Excel menu, go to the Home tab. The "Fill Colour" button is in the "Font" group. Like a paint bucket, it usually has a colour label.
Click "paint bucket" in the "Font" group.Step 3: Select the color
Please choose the colour you want to use as the fill colour by clicking on it in the palette.
Select the colorStep 4: Click on it to apply
Choose a colour, and then the cells will be filled with that colour.
Applying formatting to several cells at once is easy with the Format Painter. Copying the formatting of a specific cell or range to another location in your spreadsheet is simple with this helpful function.
Step 1: Click on a cell with the style
Pick out the cell that features the style you wish to copy.
Click on a cell with the styleStep 2: Locate the Format Painter section at Home
Go to home and find the Format Painter section.
Locate the Format Painter section at HomeStep 3: Click on it
Click on the format painter when you find it.
Click on the format painter when you find itStep 4: Click on the cell for the same style
Select the cells you want to format or a range of cells, and then click and drag to apply the style.
Step 1: Copy formatting from the first cell.
Like the other cell, the format of the selected one will be modified.
Cell Styles
Excel has built-in cell styles, so you can forget to manually format cells. Cell styles in Excel make it easy to professionally arrange the contents of cells, like titles and heads.
Step 1: Select the cells
Select cells where you want to apply a cell style.
Select the cells Step 2: Click the Styles on the Home
On Home, click Styles and choose the style from the dropdown menu.
Click the Styles on the HomeStep 3: Select the style and press enter
Select a cell style and press enter to apply it to selected cells.
Select the style and press enter One of Excel's powerful features is applying specific formatting to numbers. Formatting allows you to vary the look of dates, times, decimals, percentages, currency ($), and much more rather than presenting all cell information similarly.
Step 1: Select the cells
Select cells to apply formatting.
Select the cellsStep 2: Click the dropdown menu in the "Number" group
Click the dropdown menu in the "Number" group to choose a number format.
Click the dropdown menu in the "Number" groupStep 3: Select the Number format
Choose from the available choices (Date, Time, Currency, Percentage, etc.) by scrolling down the page.
Select the Number formatStep 4: The selected formatting will be applied
Once you've chosen a formatting option, it will be applied to the selected cells.
Conclusion
Excel-style rules can help your data look better and be easier to understand. For neat and professional-looking spreadsheets, learn how to use the Format Painter, change fonts, sizes, and colours, align text, add borders and colours, and apply cell styles. The skills listed here make your work look better and help you organise knowledge so it's easier to understand.
Similar Reads
Formatting Charts in Excel
One of the major uses of Excel is to create different types of charts for a given data set. Excel provides us with a lot of modification options to perform on these charts to make them more insightful. In this article, we are going to see the most common "Formatting" performed on charts using a suit
3 min read
Data Formatting in Excel
In Excel, the whole entered data in the sheet uses the same formatting by default which can make the data look monotonous, dull, and difficult to read. Excel provides a pool of tools called formatting tools which customize the data in such a way that it only affects the appearance of the data and no
3 min read
Excel Format Painter
Imagine you spend a lot of time making a cool-looking chart in Excel, with just the right colors and fonts. But then you need to copy that look to other charts. No need to do it manually! Excel's Format Painter is like a copy-and-paste button for formatting. You just pick the pretty chart, click the
7 min read
Custom Excel Number Format
MS Excel is a very important tool for businesses as well as for individuals with very useful features and tools. It is a market leader in spreadsheet editing and managing software. MS Excel contains many inbuilt number formats that can be used as per the needs of the user, however, sometimes users m
2 min read
Format Reports in Excel
Excel 2013 introduces the Format pane. It offers advanced formatting choices in clean, bright new task windows, and it is also highly useful. When you alter the theme, it is applied to all Power View Views in the Report and Sheets in the Workbook. You may also modify the size of the text in all of y
4 min read
How to Change Date Format in Excel
You know that Excel is one of the best spreadsheets you can work on. Excel is the first preference of many users to create an impressive data set. Have you tried filling in the Date on the sheet? Date with the data is a common practice done by users in Excel to get information timeline. To help orga
8 min read
File Formats in MS Excel
Ever wondered how to save your Excel work so it works perfectly for you or others? Microsoft Excel lets you save your spreadsheets in different file formats, like XLSX, CSV, or XLS, each with its purpose. These file formats or extensions of MS Excel are important because they determine the structure
15 min read
How to use Conditional Formatting in Excel?
Microsoft Excel is a software that allows users to store or analyze the data in a proper systematic manner. It uses spreadsheets to organize numbers and data with formulas and functions. MS Excel has a collection of columns and rows that form a table. Generally, alphabetical letters are assigned to
4 min read
What is a Cell in Excel?
MS-EXCELÂ is a part of Microsoft Office suite software. It is an electronic spreadsheet with multiple rows and columns, used for organizing data and performing different calculations. A spreadsheet takes the shape of a table, consisting of rows and columns. A cell is created at the intersection point
6 min read
Excel Date and Time Formats With Examples
Excel stores dates as serial numbers and times as fractional values of a day, which means what you see on the surface is often just a formatted version of something else entirely. If you're not familiar with how Excel handles these values, your data might display incorrectly or unexpected results in
4 min read