5,244 reputation
1621
bio website teylyn.com
location New Zealand
age
visits member for 2 years, 8 months
seen 2 days ago

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


May
28
answered Excel 2013: Is it possible to collapse rows only in a specific column?
May
27
answered Set Excel 2010 save location to most recently used (“saved to”) folder
May
27
answered Highlighting Cells in Excel based on the Value Associated with the Cell
May
26
comment Make Excel understand month names in english
What do you mean? The second formula DOES do it without a helper column. Did you not read the answer?
May
26
answered is it possible to create a hyperlink in excel from the cell text?
May
26
revised MS EXCEL - Conditional formula?
added 42 characters in body
May
26
answered MS EXCEL - Conditional formula?
May
26
revised How to make a 3D chart in excel
typo
May
25
answered How to make a 3D chart in excel
May
25
answered Make Excel understand month names in english
May
25
answered Total row doesn't work properly, Excel 2010
May
24
comment Print preview doesn't work properly in Excel 2010
If you don't have a printer installed, Excel will use some default printer settings to try and render the file in print preview. If you install a printer driver for a printer that will most likely be used to print the file on another computer, then install that printer driver for a more accurate print preview.
May
23
comment Print preview doesn't work properly in Excel 2010
Even if you don't have that printer connected, install the printer driver.
May
23
answered Print preview doesn't work properly in Excel 2010
May
22
answered How to get yes or no if a specific format is true or false in excel 2013
May
21
comment Trouble using Excel OFFSET function
+1 -- it's easier and saves much, much time and headache down the line to use proper data architecture (raw data in one sheet, reporting in other sheets), than to develop and maintain functionality to coax information out of bad data architecture.
May
21
answered Excel Chart Timeline
May
19
comment Toggled Hyperlink with If:Then formula
Just use the hyperlink cell style. You can then use conditional formatting to remove the color and underline when the cell shows '(NOT IN USE)'. Excel does not apply the hyperlink formatting unless it recognizes that the cell contains a hyperlink. Nesting the Hyperlink() function within an IF() function obscures this recognition.
May
18
answered Toggled Hyperlink with If:Then formula
May
18
answered Select cells based on other column