Excel 2016 2013 2010 2007 2003

Cell format to round off to thousands, millions, billions

Many of us live in the information space with the calculations performed with precise data expressed in cents or even more granular amounts. Still, it is advisable to present them in thousands or even millions in presentations and reports.

Move entire column or entire row in Excel

Sometimes you need to reorder columns or rows in Excel. If your data does not contain formulas, the procedure does not seem complicated – copy/paste works well for the plain data cells. However, when you try to move data with formulas, you may run into problems.

How to format negative timestamps

Excel supports different formats for positive and negative numbers. You can combine text and formatted values to make the display more presentative. Another numeric format is a timestamp, and you can find a difference between two timestamps and display it in days, hours, and minutes. However, Excel does not handle well negative timestamp differences.

Hide spreadsheet tabs

Excel opens many ways to get more workspace, such as collapsing the Ribbon, hiding the Formula bar, hiding column and row headers, and even hiding spreadsheet tabs. If you have only one worksheet in your workbooks, or you want to disable access to other spreadsheets of the workbook without hiding them one by one, you can hide all spreadsheet tabs in your local environment:

How to hide, display, and expand the Formula bar

The Formula bar displays data and formulas for the current cell in Microsoft Excel. You can expand the formula editor if the data or formula does not fit and hide the formula bar if you need more screen space.

Column and row headers

Column letters and Row numbers are principal features of Excel spreadsheets. Using Column letter and Row number, you can address any cell - the main element in Excel.

How to work with a large number of objects in Excel

When you work with many graphical objects such as pictures, charts, text boxes, shapes, etc., it is sometimes challenging to select one of the objects - it can lay behind other objects, or it can be too small, etc.
Excel proposes an excellent feature named Selection pane to help navigate between different objects and groups.

4 Reasons to Use Excel for Your Monthly Budgeting

We often misunderstand the meaning of budgeting, associating it with austerity and savings, which are traditionally perceived negatively. Some believe that only those who are short of money need a budget. However, it's not true - we all need budgeting not to save but to control our income and expenses.

CustomGuide's Microsoft Excel Training

Microsoft Excel has been a common name with several business professionals; however, only a few can master the platform. With more than 400 functions in the program, it can be overwhelming for anyone. Excel is undoubtedly one of the most sophisticated computer programs with a lot of functionality beneath its surface. For people who are just starting, it can be intimidating to learn, and this is why enrolling yourself in a Microsoft Excel Training program can come in handy.

Formatting comments

Like a regular text, the comment boxes can be formatted. Excel provides many formatting options and allows you to customize most aspects of its appearance, including color, border, and margins.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more