How Do I Use Excel to Create a PDF into a Folder According to a Cell?

How do I use Excel to create a PDF into a folder according to a cell name?

Below is a listing of all the major shortcut keys usable in Microsoft Excel. F2 - Edit the selected cell. · F3 - After a name has been created, F3 will paste names. · F4 - Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color. · F5 - Go to a specific cell. For example, C6. · F7 - Spell check selected text or document. · F11 - Create chart from selected data. · Ctrl+Shift+; - Enter the current time. · Ctrl+; - Enter the current date. · Alt+Shift+F1 - Insert New Worksheet. · Alt+Enter - While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell. · Shift+F3 - Open the Excel formula window. · Shift+F5 - Bring up search box. · Ctrl+1 - Open the Format Cells window. · Ctrl+A - Select all contents of the worksheet. · Ctrl+B - Bold highlighted selection. · Ctrl+I - Italic highlighted selection. · Ctrl+K - Insert link. · Ctrl+S - Save the open worksheet. · Ctrl+U - Underline highlighted selection. · Ctrl+D - Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell. · Ctrl+R - Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell. · Ctrl+1 - Change the format of selected cells. · Ctrl+5 - Strikethrough highlighted selection. · Ctrl+P - Bring up the print dialog box to begin the printing process. · Ctrl+Z - Undo last action. · Ctrl+F3 - Open Excel Name Manager. · Ctrl+F9 - Minimize current window. · Ctrl+F10 - Maximize currently selected window. · Ctrl+F6 - Switch between open workbooks or windows. · Ctrl+Page up - Move between work sheets in the same document. · Ctrl+Page down - Move between work sheets in the same document. · Ctrl+Tab - Move between Two or more open Excel files. · Alt+= - Create a formula to sum all of the above cells. · Ctrl+' - Insert the value of the above cell into the cell currently selected. · Ctrl+Shift+1 - Format number in comma format. · Ctrl+Shift+4 - Format number in currency format. · Ctrl+Shift+3 - Format number in date format. · Ctrl+Shift+5 - Format number in percentage format. · Ctrl+Shift+6 - Format number in scientific format. · Ctrl+Shift+2 - Format number in time format. · Ctrl+Arrow key - Move to next section of text. · Ctrl+Space - Select entire column. · Shift+Space - Select entire row. · Ctrl+ - Delete the selected column or row. · Ctrl+Shift+= - Insert a new column or row. · Ctrl+Home - Move to cell A1. · Ctrl+~ -Switch between showing Excel formulas or their values in cells. Most useful Excel Formulas . - 1. SUM - Formula. =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1.B5) It allows you to add 2 or more numbers together. You can use cell references as well in this formula. 2. COUNT – Formula. =COUNT(A1.A10) The count formula counts the number of cells in a range that have numbers in them. 3. COUNTA - Formula. =COUNTA(A1.A10) It counts the number of non-empty cells no matter the data type. 4. LEN - Formula. =LEN(A1) The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces. 5. TRIM - Formula. =TRIM(A1) Gets rid of any space in a cell, except for single spaces between words. I’ve found this formula to be extremely useful because I’ve often run into situations where you pull data from a database and for some reason extra spaces are put in behind or in front of legitimate data. This can wreak havoc if you are trying to compare using IF statements or VLOOKUP’s. 6. RIGHT, LEFT, MID - Formulas. = RIGHT(text, number of characters), =LEFT(text, number of characters), =MID(text, start number, number of characters). These formulas return the specified number of characters from a text string. RIGHT gives you the number of characters from the right of the text string, LEFT gives you the number of characters from the left, and MID gives you the specified number of characters from the middle of the word. You tell the MID formula where to start with the start_number and then it grabs the specified number of characters to the right of the start_number. 7. VLOOKUP - Formula. =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) Vlookup is used for find value in table array. It is very useful function for matching two data base on common value. Suppose you have thousand of order details in which you have to find few hundred order in master data weather these are exit in your master order data or not. 8. IF Statements - Formula. =IF(logical_statement, return this if logical statement is true, return this if logical statement is false) When you’re doing an analysis of a lot of data in Excel there are a lot of scenarios you could be trying to discover and the data has to react differently based on a different situation. 9. MATCH - Formula. =MATCH (lookup_value, lookup_array, [match_type]) MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. 10. INDEX - Formula. =INDEX (array, row_num, [col_num], [area_num]) The Excel INDEX function returns the value at a given position in a range or array. You can use index to retrieve individual values or entire rows and columns. INDEX is often used with the MATCH function, where MATCH locates and feeds a position to INDEX.