Smartxyz

Author's details

Date registered: 2010/10/16

Latest posts

  1. Excel: VBA Examples-3 — 2011/12/28
  2. Excel: VBA Examples-2 — 2011/12/27
  3. Excel: VBA Examples-1 — 2011/12/26
  4. Word: Fast way to cut and paste. — 2011/12/24
  5. Word: Fast way to change the line space. — 2011/12/24

Most commented posts

  1. How to diff two columns in excel. — 132 comments
  2. How to update excel data according another data source? — 132 comments
  3. How to manage the information get from web? — 131 comments
  4. Office: How to copy the format? — 123 comments
  5. How to set proxy for firefox easily. — 119 comments

Author's posts listings

Dec
24

Office: How to copy the format?

Most word userknow, when select part of the word, press the format bruch button can get the format of the selected words. Use this brush can change the format of other words.But after this, the format brsuh not available any more. If you want to repeat the format brush, you have to repeat above steps.… Continue reading »

Dec
24

Excel: How to get the value of part of the formula?

When we make an excel sheet, sometime we need input a long formula. If there is only two or three formulas in the cell, it’s easy. If there is more than 3 formulas in a cell, it’s difficult to check the error in the cell. This tip help to make it easy. For example. If… Continue reading »

Dec
22

Excel: How to change the rows to columns?

After you finished a sheet, you find the rows and columns are not exactly what you want, you want to switch the rows and columns. How to do this? Select the cells at first, then copy them. Then select another empty sheet, right click the mouse, select “Transpose(T)” to paste the range.

Dec
22

Excel:How to hide cells?

Hide the value in all cells. Right click the cell, select “Format cells”->”Number”. Select Category->Custom input ;;;. You can also set the font of the text to white which is same as the background. This way is too common and easy to be cracked by others.

Dec
22

Excel: How to input a formula fast?

For example, you want to input same formula from B3 to B20. You can select B3 to B20 at first, then press F2 to input formula. After input press Ctrl+Enter. Then all the cells in the range will be filled same formula. You can also select multi cells not Adjacent to do this.

Dec
22

Excel: How to select a cell with hyperlink?

It’s difficult to select an cell with hyperlink. When you click the cell, will directly go to the link target. If you want to select the cell and not goto the link target, just click the cell and keep press the mouse until the cursor change to “+”, then release the mouse. Another way, you… Continue reading »

Dec
22

Excel: How to name range immediately?

First, select the cells, then click the name input box on the toolbar, input the range name directly. Later you can refer the range by name. Name of range is very useful. First it’s easy to be remembered. Second, when you changed range, you just need change the range and rename it. You don’t need… Continue reading »

Dec
22

Excel: How to change faster between absolute reference and relative reference.

When design formula, need using different cell reference, you can use following method to switch between cell reference. Select the cell has formula, select the reference need change, press F4, switch between absolute reference and relative reference. For example “A1” is selected, press F4 repeatedly, will change between $A$1,A$1,$A1,A1.

Dec
22

Excel shortcuts.

Tip Download or print a Quick Reference Card: Keyboard Shortcuts – Ctrl keys. (PDF) Key Description CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+PgDn Switches between worksheet tabs, from right-to-left. CTRL+SHIFT+( Unhides any hidden rows within the selection. CTRL+SHIFT+& Applies the outline border to the selected cells. CTRL+SHIFT_ Removes the outline border from the selected… Continue reading »

Dec
22

Excel: How to make the row and column in same color?

When select a cell, how to make the row and column of the cell in a color? You need use VBA for this. Code is: Add code to the selection change handler of the worksheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Application.CutCopyMode Then Exit Sub ‘If in cutcopy mode, then exit sub. Dim Rng… Continue reading »

Older posts «

» Newer posts