If you want to copy a bunch of formulas to a new range of cells – this is very useful. Like that sleek table format your colleague has made? But don’t have the time to redo it yourself, worry not, you can paste formatting (including any conditional formats) from any copied cells to new cells, just hit ALT+E S T. Very useful when you want to strip away existing formatting and work with plain data. If you want to just paste the values from copied cells, just hit ATL+E followed by S and V.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |