When trying to resize or position objects such as charts, autoshapes, or controls on a spreadsheet, with the intent of aligning them to edges of cells, you can hold down the ALT key while doing so. This will have the effect of “snapping” the object to the cells.

I recently exported some emails from Outlook into an Excel file. I wanted to get the contents into a file so that I could use the address details that had been in the emails.
Outlook exports the email body into one cell and adds carriage returns to the text. I needed to convert the carriage returns and “box” characters into something that I use to to Delimit the text.

This is what I did. I created the following VBA routine. The first line takes out the carriage returns and replaces them with a semi colon. The second line replaces the box characters with a tilde.
Sub fixme()
ActiveSheet.UsedRange.Replace what:=Chr(10), replacement:=";" 'this is the carriage return
ActiveSheet.UsedRange.Replace what:=Chr(13), replacement:="~" 'this is the box character
End Sub

I can then highlight the text and convert it to columns using the Text to Columns feature in Excel.

Having Excel automatically enter consecutive numbers.

You may want to enter consecutive numbers in a row of cells. Excel has a nice feature that will do it automatically for you. To do this:

* Enter the first number of the string into a cell.
* Press and hold the Ctrl key.
* While the Ctrl key is pressed, click the cells fill handle (the small black square) and drag it over the range in which you want it to fill in consecutive numbers automatically.
* Let go of the mouse button.
* Let go of the ctrl key.

Now, your consecutive numbers will be automatically filled in.