Sometimes you may wish to keep a part of an Excel worksheet stick on top while you are working or scrolling through your worksheet. To do this, you will need to freeze the area so that it remains locked and constant when you are scrolling through your workbook. This is an easier task to achieve […]
How to keep one row in Excel on top Read More »
By default, all Excel spreadsheets have gridlines. These are lines you can see, the horizontal and vertical faint lines, which divide the worksheets into cells. The gridlines help the users to organize the data into rows and columns. They guide the users to differentiate between the specific cells and be able to read the data
How to remove gridlines in excel outside table: 4 easy ways Read More »
In this article, we shall discuss how you can move the $ sign close to a number in Excel. When dealing with money on Excel, it is important to use currency symbols. This helps differentiate different currencies. Besides, it helps to differentiate money from other types of data. Excel editing tools are not straightforward like
How to move $ closer to a number in Excel Read More »
After working on Excel worksheets, you may need to print out your workbook. Printing comes with different editing features. You can specify custom margins, change margins, or even center your worksheet to be printed vertically or horizontally. Excel also offers users printing features that enable them to print workbooks in the middle of the page.
3 easy ways to print Excel in the middle of a page Read More »
Excel has a lot of tricks within it to solve some simple mistakes and increase productivity. However, some things might be missing in excel and may lead to frustrations. In the past, excel didn’t have some of the things like deselecting in Excel after copying. Thanks to the excel team, they have taken the user’s
How to deselect in Excel after copying Read More »
Using a watermark in Excel is a common way of identifying files that belong to a creator and protecting these files from unauthorized use or access. Watermarks help prevent your data from being plagiarized or used by another person as their own. A watermark may be an image, a company’s logo, or a distinct object.
How to insert a watermark in Excel behind the text Read More »
When going through Excel worksheets, you may have come across worksheets that have a line drawn through data and end up wondering how it is done. That is strikethrough formatting. Although it is hardly used, it is a good method to visibly show that something is no longer relevant, it has been removed from your
How to strikethrough in Excel: (4 methods) Read More »
Sometimes you may work with large worksheets containing very detailed information. Such worksheets may be hard to read, analyze or visualize therefore calling out the need to organize your worksheet. In Excel, this is possible as you can organize your data by combining subcategory data. You can group rows to enable one to easily understand
How to group rows in Excel under a heading (Easy Guide) Read More »
When you hear about flipping texts and data in Excel, it may seem like a one-click trivial task. Surprisingly, this is not the case as there is no built-in feature that makes this easier with the click of a button. But what if, in that special case, you want to go flip your data upside
How to flip data in Excel upside down Read More »
When working with Excel worksheets, you can select an entire row by clicking the row number at the left edge of the window. But doing so ends up selecting the entire row up to infinity. You can also easily select multiple rows in your worksheet using different ways. In the guide below, we let you
How to select rows in Excel till the end- 5 methods Read More »
