From the course: Microsoft Project Quick Tips
Copy data into adjacent rows
From the course: Microsoft Project Quick Tips
Copy data into adjacent rows
- [Instructor] With a Project keyboard shortcut you can quickly copy data into adjacent cells in a column. Drag over the cell with the value you want to copy and the cells you want to copy into. Then press Ctrl+D, Project copies the value from the first cell into the remaining cells in the selection. You can also use the mouse to copy a value into adjacent cells. Click the cell with the value you want to copy. Hover the pointer over the bottom right corner of the cell. When the pointer changes to a plus sign, drag in the column over the cells you want to copy into. When you let go of the mouse Project copies the value from the first cell into the cells you drag over.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Copy data into adjacent rows56s
-
(Locked)
Quickly insert multiple tasks54s
-
(Locked)
Enter values quickly with a lookup table1m 30s
-
(Locked)
Wrap text in table cells1m
-
(Locked)
Align cell data1m 5s
-
(Locked)
Copy cell formatting1m 17s
-
(Locked)
Change currency formatting1m 4s
-
(Locked)
Adjust column and row size in Project1m 5s
-
(Locked)
Align task bars within rows1m 22s
-
Change magnification in the timescale1m 22s
-
(Locked)
Display only incomplete tasks1m 6s
-
(Locked)
Expand and collapse the task list1m 30s
-
(Locked)
Insert and hide columns in a table1m 24s
-
(Locked)
View the selected task in the timescale39s
-
(Locked)
View two parts of a project1m 16s
-
(Locked)
Set the default view46s
-
(Locked)
Insert hyperlinks1m 4s
-
(Locked)
Move to the beginning or end of the timescale1m 3s
-
(Locked)
Toggle between panes in a window59s
-
(Locked)
Customize the Quick Access Toolbar1m 8s
-
Indent and outdent tasks quickly1m 15s
-
(Locked)
Switch tasks between manual and auto scheduling54s
-
(Locked)
Create an image of a schedule1m 29s
-
(Locked)
Share customization with colleagues1m 27s
-
(Locked)
Change sort order1m 39s
-
(Locked)
Remove all filters when AutoFilter is active59s
-
(Locked)
Filter by date range48s
-
(Locked)
Create a template from a project1m 28s
-
(Locked)
Use a template to create a project1m 24s
-
(Locked)
Set file save options1m 17s
-
(Locked)
Protect a file with a password1m 19s
-