Message:Coronavirus (COVID-19)

Blog

Posts Tagged ‘excel’

Microsoft Excel blamed for gene study errors

August 25th, 2016 by Mark Daly in Industry News No Comments »
Share Button

Microsoft’s Excel has been blamed for errors in academic papers on genomics. Researchers trying to raise awareness of the issue claim that the spreadsheet software automatically converts the names of certain genes into dates. Gene symbols like SEPT2 (Septin 2) were found to be altered to “September 2”. However, Microsoft, which released the first version […]

How to Manually Calculate Only the Active Worksheet in Excel

April 29th, 2016 by Mark Daly in Industry News No Comments »
Share Button

If you have large workbooks with a lot of formulas on the worksheets, recalculating the workbooks can take a long time. By default, Excel automatically recalculates all open workbooks as you change values in the worksheets. However, you can choose to recalculate only the current worksheet manually. Notice I said worksheet, not workbook. There is […]

How to Create a Copy of an Excel Worksheet Without Formulas

April 26th, 2016 by Mark Daly in Industry News No Comments »
Share Button

Say you’ve created an Excel workbook you need to distribute, but you can’t reveal the formulas you used in that workbook. We’ll show you an easy trick that allows you to copy a worksheet to another workbook and quickly remove the formulas, so only the results show. This method allows you to move or copy worksheets […]

How to See All of the Named Cell Ranges in an Excel Workbook

April 21st, 2016 by Mark Daly in Industry News No Comments »
Share Button

Naming a range of cells in Excel provide an easy way to reference those cells in a formula. If you have a workbook with a lot of data on the worksheets, naming ranges of cells can make your formulas easier to read and less confusing. But if you have a particularly big spreadsheet, you may not remember […]

How to Open Certain Workbooks Automatically When You Start Excel

February 4th, 2016 by Mark Daly in Industry News No Comments »
Share Button

If you use a few Excel spreadsheets daily, it would be handy if you could open those spreadsheets automatically every time you start Excel. Thankfully, Excel has this feature built-in–if you know where to look. For example, maybe you open a time sheet file every day to keep track of your hours as you work […]

NEED MORE INFORMATION?Contact us to see how we can help your business

Call our Sales Team on:

+44 (0)121 289 3434

or email us at:

hello@ilicomm.com