by Ilker | Sep 2, 2019 | Excel Tips & Tricks
You can easily increase the column width to fit more contents into a smaller area. However, increasing the column width means that you’re going to be able to use fewer columns. Changing the alignment of the text can help overcome these limitations and allow you...
by Ilker | Aug 29, 2019 | Excel Tips & Tricks
Hiding zero (0) values in Excel can be especially helpful for de-cluttering your workbooks and in most cases, make them easier to read. In this guide, we’re going to show you how to hide zeros in Excel worksheets, following three different methods. How to Hide Zeros...
by Ilker | Aug 28, 2019 | Excel Tips & Tricks
In this guide, we are going to show you how you can open all files in a folder on startup. Excel allows selecting a specific folder to open the files in it automatically when Excel starts. This can be a project or template folder, or just a folder on the network used...
by Ilker | Aug 23, 2019 | Excel Tips & Tricks
Clicking on the sheet name on the bottom of the window is the most straightforward way of tab navigation in Excel, but there’s more! Some of the other methods we’re going to take a look at here can be especially helpful when dealing with a large number of...
by Ilker | Aug 19, 2019 | Excel Tips & Tricks
Do the Excel grildine color not match the look-and-feel of your application, or are you just bored of the classic gray colors? Even though you can use border coloring to change those colors, there is an even better way to do this without applying a formatting to all...
by Ilker | Aug 8, 2019 | Excel Tips & Tricks
If your worksheet contains multiple pages, you will see header rows or columns only printed in the first page by default. In this article, we are going to show you how to print header row in Excel to repeat on every printed page in Excel 2016, Excel 2013, Excel 2010...
by Ilker | Aug 1, 2019 | Excel Tips & Tricks
The headings in Excel are essentially the screen guides that make working with cells or ranges easier. By default, row and column headings in Excel don’t show in printed documents. If you want to print them anyways, Excel has an option which allows including row...
by Ilker | Jul 30, 2019 | Excel Tips & Tricks
The grid structure is an important feature that helps distinguish between sections, and build an interface easily when using spreadsheets. They are the guide in this structure that makes each cell distinct from other. If you want the gridlines that appear on...
by Ilker | Jul 19, 2019 | Excel Tips & Tricks
Excel comparison operators can compare two values and return a logical (Boolean) value. You can use the return logical value in other functions like IF, or features, like Conditional Formatting, that require a logical value input. In this guide, we are going to show...
