Formatting Articles: Excel and Google Sheets

All resources related to Formatting for Excel and Google Sheets.
All articles Formatting

Formatting

How to Control the Layout and Formatting of Your Excel Spreadsheets
Excel spreadsheets allow you to perform a ton of calculations and keep your data organized, but it's often viewed as a boring utility tool. Yes, Excel is useful, but you can make it even more functional and easy to view by adding some formatting and style to your spreadsheets.  Proper...
How to Create an Excel Custom Number Format – Excelchat
There are various built-in formats for numbers like currency, accounting, date, time, percentage, etc. A custom number format is a special code of how we want to display the numbers in cells without changing the actual numeric values. We can create a custom format of numbers to display insignificant zeros,...
How to Make Multiple Lines in Excel Cell – Excelchat
When we enter long text in a cell then it is not shown completely to read. We can make it happen to put multiple lines in a cell to show the long text on more than one lines in a single cell. Figure 1. Multiple Lines in One Cell How...
How to Stop Excel From Changing Numbers to Dates
Excel stores dates as serial numbers, therefore when we enter a number like 4/20 into a cell, Excel changes the number to date as 20-Apr. Excel is programmed in this way, so we need to apply some fixes and learn how to stop Excel from changing numbers to dates. Figure...
How to Add Borders in Excel
The borders are added to selected cells to make them visually appealing for drawing the reader’s attention. We can add borders of various styles to any or all the sides of the selected range of cells by learning how to add borders. Figure 1. Insert Border How to Apply Borders...
How to Remove Table Formatting in Excel
Excel provides a variety of built-in table styles with various formatting options of fonts, background colors, borders, banded rows to manage and improve the look of data. There may be a time where we do not require applied table formatting. Therefore, we need to learn how to remove table formatting....