Static Time Excel

Excel's NOW function displays the current date and time formatted according to the regional options you've set for Windows.

If you just want to see only the date, instead use the TODAY function.

You can't use either of these functions as a timestamp, though, because they automatically update when your spreadsheet is calculated or re-opened. For example, a cell displaying today's date will display tomorrow's date if you open the spreadsheet tomorrow.

To insert a date that won't change into a cell, hold down Ctrl while pressing the semicolon ( ;) key. To insert the current time sans date, press Ctrl-Shift-Semicolon.


How to Disable Laptop Touchpad/Touchstick When Using External Mouse

To disable your laptop's touchpad or touchstick when using an external mouse, go to Control Panel then Mouse.  Next, select disable or disable when external USB mouse attached.  If do not see these options, download drivers for your laptop's touchpad and/or touchstick.

Difference Between Carriage Return and Line Feed

What's the difference between carriage return (CR) and line feed (LF)?

Carriage Return (CR) means return to the beginning of the line. It tells a Teletype machine to bring the print head back to the left. CR is represented by ASCII code 13.

Line Feed (LF) tells a printer to move the paper up 1 line. It's ASCII code 10

Both commands terminate a line of text and start on a new line.  But different operating systems have their own way of handling the use of LF and/or CR. Windows ends all lines in text files with CR LF, with CR taking precedence. Meanwhile, Unix uses only LF. To top it all off, Mac terminates lines with the CR character. This means Mac, Unix, and Windows text documents are all going to be a bit different and at times incompatible.  You can use a text file editor such as Notepad++ to view end of lines to make any changes if the difference is breaking a process.


Using REPT to Make Microcharts in Excel

While Excel 2013 and 2016 have sparklines for microcharts, they don't always do what you want, like make horizontal bar charts (you can do column, line charts, and win-lose graphs however).  And older versions of Excel don't have sparklines.

You can atone for that to an extent by using the REPT function as explained in this article at Chandoo's Excel Blog.  Chandoo is an Excel authority and does a great job of showing what REPT can do for you.