Formatting Articles: Excel and Google Sheets

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...

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,...

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...

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...

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...

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....