SET UP A PERMANENT 'CLIPBOARD' WITH INFO I CUT AND PAS...

[JEANNIE]

I USE EXCEL TO PUT TOGETHER QUOTATIONS FOR MY CUSTOMERS. I TYPE IN THE
FOLLOWING SIZES ALL THE TIME - 1/4" 1/2" 3/4" 1" 11/4" 1 1/2" 1 3/4" ALL
THE WAY THROUGH TO 36" (THOUGH NOT ALL IN 1/4" INCREMENTS) I MAY TYPE
HUNDREDS OF SIZES INTO A DOCUMENT.
UP TO YET, EVERY TIME I HAVE OPENED A NEW DOCUMENT, I HAVE BEEN TYPING IN
ALL THE DIFFERENT SIZES I USE INTO AN INDIVIDUAL CELL AND THEN COPYING THEM
TO A CLIPBOARD. I THEN CLICK THE CELL I REQUIRE, AND THE SIZE I REQUIRE ON
THE CLIPBOARD AND THE SIZE IS TRANSPORTED TO THE DOCUMENT. UNFORTUNATELY I
HAVE TO SET UP THIS CLIPBOARD EVERY TIME I START A NEW DOCUMENT... OR DO I?
HOW CAN I SET UP A PERMANENT 'CLIPBOARD' SPECIAL TO WHAT I NEED?

 

[Paul Corrado]

Possibly you could make a Template and open that each time you wish to start
a new customer quote

To create a Template

Set up an Excel spreadsheet with the standard information you require the
File/Save As and select Excel Template from the File Type drop-down at the
bottom of the window

 

[Mike Q.]

Hi Jeannie

Maybe you could use Tools>>AutoCorrect and give your sizes
names like 1q 1h 3q elq oaoh oatq ect.

 

[Stephen Bye]

Also, use Data Validation so that you can select an entry from a drop-down
list instead of typing it.