办公软件使用教材!全套!excel word ppt（办公软件使用教材! 全套! excel word ppt）.docVIP

办公软件使用教材!全套!excel word ppt（办公软件使用教材! 全套! excel word ppt） 55. input numbers, words, dates or time Click the cell that you need to input data, type in the data and press Enter or Tab key. If it is time for a slash or minus separated date of the year, month, day, for example, you can type 9/5/96 or Jun-96. If you press the 12 hour input time, please empty the grid after the time number, and type the letter a (morning) or P (afternoon), for example, 9:00 P. Otherwise, if only the time number is entered, Excel will be processed according to AM (morning). 56. fast input euro symbol First press the Alt key, then use the right digital keyboard (commonly known as small keyboard), type 0128 of these 4 numbers, release the Alt key, you can enter the euro symbol. 57. converts the cell region from a formula to a value Sometimes, you might need to convert a formula in a cell region into a value. The conventional method is to convert data with the value option in selective paste. In fact, there is an easier way: first select regional cell contains a formula, hold down the right mouse button to drag the region along any direction in a short distance (do not release the mouse), and then drag it back in the original position of the cell area (at this time, release the mouse cell border becomes spent). Select copy only the value from the shortcut menu. 58. fast input ordered text If you often need to input some regular sequence text, such as numbers (1, 2...) Date (1 days, 2 days) Etc., You can use the following method to implement the quick input: first input the first two elements of the text in the first, second, two cells which need to input the sequence text, such as a and B. At the same time, select these two cells, the mouse will be moved to the second lower right corner of the cell into a fine cross line when (we usually called fill handle), press the left mouse button to drag back (or down) the last cell need to fill in the sequence, release the left mouse button, then the se