It’s all too possible that our eyes have automatically adjusted to seeing our worksheets in gridlines. It should be no surprise when we print the sheet and then find it rather… plain. And gridline free, which is why what you have been seeing as this:Turns out like this when printed:This is not the age to waste paper, folks. Let’s do it … [Read more...]
How to Indent in Excel (3 Easy Ways + Shortcut)
If you punch some text in Excel and hit the enter key, you'll notice that the text is left-aligned by default and that's what we're trying to change today. We will talk about indenting text in a cell in Excel. Indentation has all to do with the alignment of text. This is why you will find the indent options in the alignment sections in … [Read more...]
How to Lock Formula Cells & Hide Formulas in Excel
The need for locking cells comes with the ease of editing in Excel. Think of a calculation that has multiple columns referenced within the formula (e.g. net salary using taxes, allowances, and bonus calculations). If accidentally one value is changed, it affects the whole string of calculations and consequently the final amount (not to mention … [Read more...]
How to Copy And Duplicate a Sheet in Excel
We could be copying multiple formats from one sheet to another for the ease of filling data in for daily, weekly, or monthly reports. We could be copying data for adding in the analytics. We could very well be copying a to-do list to forever keep score. For whichever act it is that you choose to team up with Excel, we are here again to give you the … [Read more...]
How To Wrap Text In Excel – (2 Easy Ways + Shortcut)
A quick look at an Excel sheet can tell you that the regular size of a cell is a decent fit for numbers but for this tutorial, we are more concerned about a cell's fit for text. With an acceptable font size, fitting 7-8 characters in a cell is no problem. For fitting more than one word in, there is no need to resort to a different column or row or … [Read more...]
Get Day Of Week From Date in Excel
Is it a weekday or weekend? Will we be partying out late on New Year's Eve during the weekend or preparing to bustle to our schools and offices the next day? Are you closed for business on a certain holiday? What day would that be? For all serious and non-serious reasons, this tutorial will show you how to convert a date into its corresponding day … [Read more...]
How to Highlight Every Other Row in Excel
Cells can be highlighted in Excel using the Fill Color option. Rows and columns are no different. As it always stands, dealing with a small dataset is no problem at all but the problem gets bigger with the bigger datasets.We just want systematic selection and highlighting. It's not too much to ask for. If you're cracking your knuckles on how to … [Read more...]
How to Combine First And Last Name in Excel
A large amount of data in Excel is sorted into many columns to keep it organized and classified. Coming to personal data, more often than not you will find that peoples' names are also split into two (or more) columns, keeping the first name and last name separate. While this helps sort and filter, which is frequently performed with the last name, … [Read more...]
