
PASTE VISIBLE CELLS ONLY
Copying cells and pasting them in to visible cells can be a problem. This is a problem when you drag the cell contents down as well as copying and pasting cell values only (i.e. not affecting the formatting). When rows are hidden in a spreadsheet, copying and pasting in to the visible cells on a worksheet will copy the data in to all the hidden rows too. Additionally, it can also cause an issue when you have filtered data or have a table of data. Usually, a straight copy an

UPPER, LOWER & PROPER
UPPER, LOWER and PROPER are three functions that are very useful and help you save time and help ensure consistency. These three functions all edit the particular case of one or more letters in a sentence (or to name it correctly a text string). They also allow you to change case sensitive data without having to retype the data again. UPPER converts the whole sentence to be written as upper-case. LOWER converts the whole sentence to be written as lower-case. PROPER converts