5,894 reputation
1823
bio website teylyn.com
location New Zealand
age
visits member for 3 years
seen 2 hours ago

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


Nov
21
answered IF and then condtional format
Nov
19
comment Why is links in an Excel workbook changing when one user opens the file?
Is that workbook shared? I.e. multiple users edit it at the same time?
Nov
18
comment Gantt Chart Template using dates
What version of Excel? What "Gantt chart Template"? Is this about a chart or about a range of cells with formatting? Please provide more detail. If all else fails, at least show us a screenshot so we can see what you see.
Nov
17
answered Excel auto fill a column with increment
Nov
17
comment A chart where the line between points does not interpolate
I've added another approach that does not require duplicate data rows.
Nov
17
revised A chart where the line between points does not interpolate
added 860 characters in body
Nov
17
answered A chart where the line between points does not interpolate
Nov
17
answered Validating the “results” of the scrollbar in Excel
Nov
17
comment Years on the X-axis on a Gantt chart created in Excel 2010
please post a sample file or at least a screenshot of your data and the chart. Use a file sharing service.
Oct
14
reviewed Approve Random Sampling in Excel based on specific criteria from other colums
Oct
9
answered Excel 2013 scatter plot
Oct
8
answered Copying worksheets in Excel
Oct
8
comment How do I get image hyperlink in text?
Post a sample file and explain in context. What do you have where?? Hyperlinks on what? Have you copied web page content and pasted it into Excel as html? And now you want to extract the URLs for the images? Please understand that we cannot see your screen. You really, really need to explain properly what you need.
Oct
8
answered Use data from a drop down list to populate table
Oct
7
answered Is it possible to make a pivot chart a subset of pivot table?
Oct
7
answered Can Excel 2010 Cell Formula Reference Another Cell For A Portion Of The First Formula?
Oct
1
comment How to bring to front a series in a scattered chart
I edited my answer to include an approach for Excel for Mac
Oct
1
revised How to bring to front a series in a scattered chart
added 908 characters in body
Sep
30
answered Create an “inverse” pivot table
Sep
30
comment How to move the dotted lines while I copy in MS excel 2013
have a look around the internet for disabling animations. There are many, many, many hits for that. Then try the exact opposite of what is suggested. Toggle hardware acceleration for example in the various dialogs and settings.