Absolute Cell References in Excel
Absolute cell references allow you to “fix” part or all of a cell reference in a formula. This can be a great time-saver when copying formulas, however, there is more to it than meets the eye…
Absolute cell references allow you to “fix” part or all of a cell reference in a formula. This can be a great time-saver when copying formulas, however, there is more to it than meets the eye…
The MOD function in Excel returns the remainder after a number is divided by a divisor. As an example, start a new spreadsheet and enter 172 into A1. This represents the number of minutes that a piece of machinery has been running (this figure is manually entered after the user has noted the value by [...]
I was recently presented with an Excel file which displayed a message every time it was opened indicating that it contained links to other files. I was assured by the owner of this spreadsheet that all links had been removed. Thanks to officearticles.com for helping me to solve the problem: Open the file with the [...]
In Word, selecting some text and pressing Shift+F3 will change the case of the selected text. It works on a cycle through the following – lower case , CAPITALS or Sentence Case. Excel does not have this feature but you can select a cell and use =UPPER, =LOWER or =PROPER. The format is =FUNCTION (CELL) [...]
Last year I wrote found a piece of VBA code (well I did find it but then adapted it so back to my original comment – I wrote a piece of VBA code) that split a Word mail merge output document (i.e. the one that is produced as a result of running a mail merge) [...]