Category Archives: Office

How To Switch Rows In Excel?

Hover your mouse over the border between the two adjacent rows until it turns into a cross-arrow icon. Click and hold your mouse and “Shift” until you see a gray line appear under the row you want to switch the data with. Let go of the mouse button, and the data will switch places. How […]

How To Group Columns In Google Sheets?

Group Rows or Columns in Google Sheets Select the rows or columns that you want to group. You can do this easily by dragging through them. Then, right-click and choose the Group option for the rows or columns you selected. How do I group data in Google Sheets? Manually group data: In Sheets, open an […]

How To Group Data In Google Sheets?

Keyboard Shortcut to Group Rows in Google Sheets Select the cells that you want to group (A2:A4 in this example) With the cells selected, hold the ALT and SHIFT keys and press the right arrow key. Select the Option Group rows 2-4. Hit Enter. How do I Group and Total in Google Sheets? Steps to […]

How To Make Collapsible Rows In Google Sheets?

Can you collapse in Google Sheets? Grouping data allows you to group rows/columns (that you can expand and collapse with a single click or a keyboard shortcut). This helps as you can make the data concise by hiding the grouped data and in case more detail is needed, you can quickly ungroup and show the […]

How To Collapse Rows In Google Sheets?

To hide a row, right click on the row number on the left of the spreadsheet and choose Hide row. To hide multiple rows in a Google Spreadsheet, click on the first row and drag across the rows you wish to hide, or hold the Shift key and click on the last row you want […]

How To Make Smileys Using Keyboard?

How do I make a smile on a keyboard? Open Microsoft Word, press alt and 1 from the 10 number video to get white smilies. if you want black colour smilies, press alt and 2. When I type :), Word turns it into a smiley face. How do you make a smiley face with your […]

How To Make A Powerpoint Presentation On Mac?

How to Make a PowerPoint on Mac Launch Keynote. Click on the “Keynote icon in the Launchpad to open it. Choose the Theme of the Presentation. Change the Layout. Add Content. Save the File. Export to PowerPoint. Is PowerPoint free on Mac? The Office 365 bundle includes six apps: Excel, PowerPoint, OneDrive, OneNote, Outlook, and […]

How To Create Jpg On Mac?

Click “File” from the Preview menu, and then click “Save As.” A dialog box opens. Type a name for the file, then click a folder on your Mac where you want to save the JPEG file. Click the “Format” drop-down menu, and then click “JPEG.” Click “Save” to save the file as a JPEG image […]

How To Convert Mov To Jpeg On Mac?

Open the Preview app. Press Command-N. From the File menu, choose Export. Change the format to JPEG, adjust the quality, give the file a name, and choose where to save it. How do I convert MOV to JPG on Mac? How to Convert a MOV to a JPEG Launch QuickTime on your computer, and click […]

How To Save As Jpeg On Mac?

Click “File” from the Preview menu, and then click “Save As.” A dialog box opens. Type a name for the file, then click a folder on your Mac where you want to save the JPEG file. Click the “Format” drop-down menu, and then click “JPEG.” Click “Save” to save the file as a JPEG image […]