You can make a worksheet more visually appealing and easier to read by centering text across multiple columns. Often you do this by merging and centering the merged cells, but it is not the only option.read more...
Excel automatically moves the cell pointer to the next cell down when you press the Enter key after entering data into a cell, but you can change this behavior to move it up, down, left, right and even stay on.read more...
Every workbook uses a palette of 56 colors, but you can change palette for the current workbook or even change the default colors for new workbooks.read more...