Flipping the data back and forth among various file types (copying to Word, over to Outlook, then re-copying back to Excel) is bound to cause formatting issues. But the system you describe sounds maddeningly over-engineered to me. Click on Outline and then click on Group toolbar.
Step 2: Select all row which needs to be in one group (As we can see the user is selected for March month data from the table) Step 3: Now go to the Data menu bar. Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Or you could let your supervisor write on a hard copy and you type the changes. Step 1: Now, look at the below data in Excel Sheet which a user wants to be grouping. Kutools for Excels Batch Insert Check Boxes utility can help you to quickly insert multiple checkboxes at once. Or your supervisor should get/learn Excel and “edit” your sheet when you turn it in. It sounds to me like your company needs the services of a good IT professional to set up some sort of environment in which your supervisor has direct access to the data that needs editing. How did you two come up with this way of doing things? If we want to insert two to three rows, select those many rows by. The shortcut keyboard key is Shift + Spacebar. We must use the shortcut key to select the entire row instantly. This may sound a little harsh, but … can your supervisor not simply edit the file in Excel? Does s/he not have Excel? Or has it but doesn’t know how to use it? What’s the barrier to simply attaching the Excel sheet to the outgoing email, rather than dumping the text into the body of the email? I don’t really get how this copy-and-paste process you describe evolved. Method 2 Using Excel Short Cut (Shift+Space Bar) We must first select the cell above which we want to insert the row.
0 kommentar(er)
