Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
SweetMonique pe Simpatie.ro
 | Femeie
23 ani
Galati
cauta Barbat
28 - 52 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
WORD:
1. select a line of text or text in a table (or anywhere), press CTRL then drag the text with your mouse to another place / cell in the table (can be another document) and you will COPY / DUPLICATE that text.
2. select a line of text, then press CTRL+SHIFT and drag that text to another place and you will have a link containing that text. If you modify the original text and update the link in the copied text, you will have the modifications also in the second place.
3. select a line of text, then press SHIFT and drag the text to another place to MOVE it there
EXCEL:
1. same as 1 from WORD, but after you press CTRL you will have to click and drag the green rectangle surrounding a selected cell or range of cells.
Modificat de TRaP (acum 6 ani)
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
Window movement between screens or minimize / maximize / cascade:
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
More Excel shortcut keys:
A few extracted from that topic:
Move to the next sheet in the workbook
........................................ CTRL+PAGE DOWN
Move to the previous sheet in the workbook
........................................ CTRL+PAGE UP
Move to the next workbook window
........................................ CTRL+F6 or CTRL+TAB
Move to the previous workbook window
........................................ CTRL+SHIFT+F6 or CTRL+SHIFT+TAB
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
Ctrl+Alt+Z to automatically go back to where your cursor has been previously
SHIFT+F5 goes back to up to three editing points, and when you press it a fourth time, it returns to where you started. When you open a document, it only “remembers” the last editing point.
|
|
| pus acum 5 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2247
|
|
Excel:
ALT + = - make autosum - you can select first empty cell after numbers, or multiple columns and rows of data including 1 column / row of blanks after data
CTRL + ; - insert today into current cell
_______________________________________
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
Excel - NAVIGATE TO FIRST AND LAST SHEET
Before Office 2013 there were 2 additional buttons in the bottom left corner to navigate to first and last sheet.
Since Office 2013 they removed those buttons and you only have the arrows to navigate sheets 1 by 1 (1 to the left, 1 to the right).
To navigate to first sheet and last sheet, press CTRL and then left click on those arrows.
|
|
| pus acum 5 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 18 ani
Postari: 2247
|
|
Display the relationships between formulas and cells
Source:
1. To display a tracer arrow to each cell that is dependent on the active cell, on the FORMULAS tab, in the Formula Auditing group, click Trace Precedents or Trace Dependents Button.
Blue arrows show cells with no errors. Red arrows show cells that cause errors. If the selected cell is referenced by a cell on another worksheet or workbook, a black arrow points from the selected cell to a worksheet icon Worksheet icon . The other workbook must be open before Excel can trace these dependencies.
2. To identify the next level of cells that depend on the active cell, click Trace Dependents Button image again.
3. To remove tracer arrows one level at a time, starting with the dependent cell farthest away from the active cell, on the Formulas tab, in the Formula Auditing group, click the arrow next to Remove Arrows, and then click Remove Dependent Arrows Button image . To remove another level of tracer arrows, click the button again.
_______________________________________
|
|
| pus acum 4 ani |
|