Posts Tagged 'Excel formatting'

How to delete blank rows in Excel quickly and safely

Empty lines can cause a lot of havoc to your worksheets on different levels and deleting them manually can be a time-consuming and error-prone process. In this article, you will learn a few simple and reliable methods to remove blank rows from your Excel worksheets. Continue reading

How to freeze rows and columns in Excel

When working with large datasets in Excel, you may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet. This can be easily done by using the Freeze Panes command and a few other features. Continue reading

How to do subscript and superscript in Excel for text and numbers

In this tutorial, you will learn many different ways to do superscript and subscript in Excel: keyboard shortcuts, custom formats, writing superscripted and subscripted characters with a mouse, and more. Continue reading

How to strikethrough in Excel

It is super easy to cross out text in Microsoft Word – you simply click the strikethrough icon on the ribbon. Naturally, you'd expect to see the same button on the Excel ribbon. But it's nowhere to be found. So, how do you strikethrough text in Excel? Continue reading

8 ways to add bullet points in Excel

Excel does not provide a built-in feature to make bulleted lists like most word processors including Microsoft Word do. But that doesn't mean there is no way to insert bullet points in Excel. In fact, there are at least 8 different ways, and this tutorial covers them all. Continue reading

Header and footer in Excel: how to insert, edit and remove

To make your worksheets look more stylish and professional, you can include a header or footer on each printed page of your document. Microsoft Excel provides a handful of predefined headers and footers to choose from, as well as allows creating your own ones. Continue reading

How to group rows in Excel to make them collapsible and expandable

Worksheets with a lot of complex and detailed information are difficult to view and read. Luckily, Microsoft Excel provides an easy way to organize data in groups allowing you to collapse and expand rows with similar content to create more compact and understandable views. Continue reading

How to capitalize first letter in Excel cells

How can we change the case of the first letter from lower to upper in Excel cells? Do we have to type each character manually into every cell? Not anymore! Today I will share three methods of capitalizing first letters in your table. Continue reading

How to insert picture in Excel: fit image in cell, add to comment, header or footer

In this tutorial, we will look at how to insert image in Excel from your computer, OneDrive or from the web and how to lock a picture to a cell so that it adjusts and moves with the cell when the cell is resized, copied or moved. Continue reading

How to align text in Excel

By default, Microsoft Excel aligns numbers to the bottom-right of cells and text to the bottom-left. However, you can easily change the default alignment or even align a column of numbers by a decimal point or a specific character. Continue reading

How to AutoFit in Excel: adjust columns and rows to match data size

Microsoft Excel provides a handful of different ways to change column width and adjust row height. The easiest way to resize cells is to have Excel automatically determine how much to widen or narrow the column and to expand or collapse the row to match the data size. Continue reading

How to change and AutoFit row height in Excel

By default, all rows on a new workbook are set to the same height. However, Microsoft Excel allows you to resize rows in different ways such as changing row height by using the mouse, auto fitting rows and wrapping text. Continue reading

How to change column width and AutoFit columns in Excel

Microsoft Excel provides a variety of ways to manipulate the column width – you can resize columns using the mouse, set the width to a specific number or have it adjusted automatically to accommodate the data. In this tutorial, you will find the detailed information about all these methods. Continue reading

How to wrap text in Excel

If large text does not fit neatly in a cell, you can simply make the column wider. However, a much better solution is to wrap text that exceeds a column width, and Microsoft Excel provides a couple of ways to do it. Continue reading

Video: Conditional formatting based on another cell

Learn how to quickly highlight entire rows based on another cell value in Excel. Continue reading

How to add leading zeros in Excel

The tutorial shows different ways to add leading zeros in Excel: how to keep zeros as you type, show leading zeros in cells, remove or hide zeros. Continue reading

How to add, copy and delete multiple checkboxes in Excel

The tutorial will teach you how to quickly add multiple checkboxes in Excel, change the check box name and formatting, as well as delete one, several or all checkboxes on a sheet. Continue reading

Excel table styles and formatting: how to apply, change and remove

After you have created a table in Excel, what's the first thing you would like to do with it? Make it look exactly the way you want! Luckily, Microsoft Excel provides a variety of predefined table styles that let you apply or change the table formatting in a click. Continue reading

How to clear formatting in Excel - remove all or only specific formats

Manually changing cell color, font, borders, alignment and other formatting options is tiresome and time-consuming. Luckily, Microsoft Excel provides a couple of quick and simple ways to clear formatting in a worksheet. Continue reading

Format Painter and other ways to copy formatting in Excel

Microsoft Excel has an amazingly simple way to copy formatting, which is often overlooked or underestimated. This tutorial shows the most efficient ways to use Excel Format Painter, Fill Handle and Paste Special to copy formatting to a selected cell, range, entire column or row. Continue reading

-->
Pages: 1 2 3
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard