Excel
Grouping & Rows & Columns. Hiding and showing lots of selected items, which then gives you a + or - on the sheet. Excel - > Data -> Group...
Mon, 22 Mar, 2021 at 9:11 AM
Clearing one cell’s format
If a whole row/column is
formatted and you want to clear just one cell’s format, click edit>clear>format
Downfi...
Wed, 28 Jan, 2015 at 1:12 PM
How to apply separate passwords
To apply different passwords to two ranges in a worksheet, follow these steps:
Start Excel, and then open a blank...
Thu, 11 Feb, 2016 at 10:42 AM
Description It is possible to nest multiple IF functions within one Excel formula. You can nest up to 7 IF functions to create a complex IF THEN ELSE st...
Wed, 4 Jan, 2017 at 11:41 AM
If cell equals Generic formula =IF(A1="red",true result,false result) Explanation If you want to do something specific when a cell eq...
Wed, 4 Jan, 2017 at 11:40 AM
Index - Match Formula
Formula can be used to pull information from one source into another place.
For example below if you would li...
Tue, 27 Jan, 2015 at 4:07 PM
Open
the spreadsheet document you'd like to apply the text restriction to.
a)
Click the "Data" tab, then
click "Data Validation.&qu...
Tue, 27 Jan, 2015 at 4:16 PM
Issue
To match / check two fields in Excel
Solution So to check if A3 is the the same as C3 you would type =A3=C3
Tue, 27 Jan, 2015 at 4:10 PM
What the IF function does
The IF function is one of Excel’s most useful and most used functions. What it does, basically, is test to see whether a c...
Tue, 27 Jan, 2015 at 3:36 PM
Issue
Unable to maximise the opened Excel Worksheet (See attachment)
Issue
Seems to be a compatibility issue between...
Wed, 24 Feb, 2016 at 4:11 PM