Copying and pasting is a normal occurrence in Excel. Most times, we are used to copying data and pasting it as it is. But what if you need to copy and paste a list of column or row data in reverse order? There is no direct in-built function in Excel that reverses a list of […]
How to paste opposite in Excel- 3 easy ways Read More »
While using excel, you need to learn how to present data in your spreadsheets. One of these important skills is inserting, editing, and removing borders in excel. The borders are important so you can separate information like headers and total rows from the rest of the table. Therefore, it is important that you know how
How to insert, edit or remove outside border in Excel Read More »
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 »
