Microsoft Office Tutorials and References
In Depth Information
Selecting data to copy and paste
Selecting data to copy and paste
In addition to a very sophisticated set of features for
exporting data, Access also supports a rich variety of techniques for
highlighting and copying data to the clipboard. If you need to
select multiple columns of data, drag the columns so that they
are positioned together and then use the Shift key to select the
columns to copy. If you need to select specific rows, use the
filter/sort techniques to order the data, and then use the Shift
key when selecting multiple rows or columns of data.
To select an area of the datasheet, click and hold as you drag
the mouse over the screen area, having used the previously
described techniques to order by row and column. To
experiment with these techniques, paste the data into another Office
application such as Word or Excel.
Select all displayed data
1
To select all data, click the top-left corner of the datasheet. Then
use Ctrl+C to copy the data to the clipboard, and use Ctrl+V to
paste the data into a spreadsheet.
1
Select a subset of all columns
1 Click to select the columns, either by using the Shift key or by
holding the right mouse button down while you move over the
columns. Then use Ctrl+C to copy the data to the clipboard, and use
Ctrl+V to paste the data into a spreadsheet.
1
Search JabSto ::




Custom Search