25.10.2018

How to Use this Shortcut List: + Indicates to hold the previous key, while pressing the next key. > Indicates to tap the previous key, releasing it before pressing the next key.

My Book for Mac Products. Portable Storage Personal Cloud. The My Passport Ultra drive comes equipped with WD Backup™ software to help make sure your photos, videos, music and docs don’t get lost. Set it to your schedule. Pick the time and frequency to auto back up files from your system onto the drive. 3TB, 2TB, 1TB. Lacdo EVA Shockproof Carrying Case for Western Digital My Passport Studio Ultra Slim Essential WD Elements SE Portable 500GB 1TB 2TB Mac USB 3.0 Portabl 2.5 inch External Hard Drive Travel Bag, Blue 4.4 out of 5 stars 339. The My Passport for Mac is WD's newest release, and was designed to specifically serve Mac users with the same out-of-the-box functionality that the My Passport Ultra offers. It maintains compatibility with PC operating systems (which requires reformatting), and it is similar in functionality and performance to the seventh generation My. My passport ultra 1tb for mac. My Passport™ for Mac is trusted, portable storage that perfectly complements your on-the-go lifestyle. Compatible with USB-C and USB-A devices, My Passport for Mac comes equipped to connect with today's latest technology. 4TB, 3TB, 2TB, 1TB. My Passport Ultra for Mac Learn More My Passport SSD Learn More My Book Learn More ENGLISH. Getting Started with a My Passport Ultra How to format a WD hard drive to exFAT or FAT32 file system. Answer ID 291. This answer explains how to setup and use WD Security and WD Drive Utilities on a Windows or Mac computer. How to install WD Security & WD Drive Utilities.

Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Let's say that you want to easily enter the current date and time while making a time log of activities. Or perhaps you want to display the current date and time automatically in a cell every time formulas are recalculated. There are several ways to insert the current date and time in a cell.

Insert a static date or time into an Excel cell A static value in a worksheet is one that doesn’t change when the worksheet is recalculated or opened. When you press a key combination such as Ctrl+; to insert the current date in a cell, Excel “takes a snapshot” of the current date and then inserts the date in the cell.

Excel mac keyboard shortcuts for date 2017

Because that cell’s value doesn’t change, it’s considered static. • On a worksheet, select the cell into which you want to insert the current date or time. • Do one of the following: • To insert the current date, press Ctrl+; (semi-colon). • (Windows) To insert the current time, press Ctrl+Shift+; (semi-colon). • (Mac) To insert the current time, press +; (semi-colon). • (Windows) To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon). • (Mac) To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press +; (semi-colon).

Insert a date or time whose value is updated A date or time that updates when the worksheet is recalculated or the workbook is opened is considered “dynamic” instead of static. In a worksheet, the most common way to return a dynamic date or time in a cell is by using a worksheet function. To insert the current date or time so that it is updatable, use the TODAY and NOW functions, as shown in the following example. For more information about how to use these functions, see. Quickbooks 2014 download intuit. Example Formula Description (Result) =TODAY() Current date (varies) =NOW() Current date and time (varies) • Select the text in the table shown above, and then press Ctrl+C.

• In the blank worksheet, click once in cell A1, and then press Ctrl+V. If you are working in Excel Online, repeat copying and pasting for each cell in the example. Note: The results of the TODAY and NOW functions change only when the worksheet is calculated or when a macro that contains the function is run. Cells that contain these functions are not updated continuously. The date and time that are used are taken from the computer's system clock. Change the date or time format To change the date or time format, right-click on a cell, and select Format Cells. Then, on the Format Cells dialog box, in the Number tab, under Category, click Date or Time and in the Type list, select a type, and click OK.

The Ultimate Guide to Office 365 We can always use a few shortcuts to save time. Here are eight useful keyboard shortcuts to speed up your work in Excel. Add border to cells PC: Alt+H, B Mac: +Option+0 If you want to add an outline (outer) border around your selected cells, just use this quick shortcut.

Insert table PC: Ctrl+T MAC: ^T Use this shortcut to quickly insert a table. You will be asked where the data is for your table, and then your table will automatically be created. Select entire row PC: Shift+Space Mac: ⇧+ Space Selecting an entire row can be a great timesaver. Use this shortcut to select a single entire row.

Bonus: Hold down Shift and the up/down arrows to select multiple rows. Select entire column PC: Ctrl+ Space Mac:⌃+ Space Likewise, selecting entire columns can be a great timesaver too. Bonus: Hold down Shift and the left/right arrows to select multiple columns. Hide rows PC: Ctrl+ 9 Mac: ⌃ 9 Sometimes it can be useful to hide rows in your worksheet. If you don’t want certain sensitive data to be visible, you can hide them (hidden rows and columns do not print). Hide columns PC: Ctrl+ 0 Mac: ⌃+ 0 7.

Copy formula from the cell above PC: Ctrl+ ‘ Mac: ⌃+ ‘ Copying the formula from the cell above is a great way to make an exact copy of a formula. Cell references will remain unchanged. Copy value from the cell above PC: Ctrl+ Shift+ ” Mac: ⌃+ ⇧+ ” If you don’t want to copy the formula from the cell above and you just want the value, you can use this useful shortcut.