## Posts

### How to renumber Beams in STAAD.Pro?

When we model the structure, the nodes, and elements gets a numerical identity. If these numbers are in sequence, it can be lot easier to find the members faster result interpretation can be done. Speed of work can be increased if we know that the elements are numbered in sequential order. Here is a way to do so:
For numbering Beams as shown below.
For beams in X direction :Select all beams of one floor level of structure. Take it to new view by right click and selecting new view. Select beams parallel to X. Go to geometry → renumber → members. Press yes to the window that asks for confirmation. Give first number from where you want to start your numbering of beams. Select available sort criteria in following sequence  Z co-ordinate X co-ordinate Click Accept.You have done it for beams in x direction.  For beams in Z direction :Select beams parallel to Z. Follow steps from 4 to 6. Select available sort criteria in following sequence X co-ordinate Z co-ordinate (descending) (it can be do…

### How to renumber Columns in STAAD.Pro?

When we model the structure, the nodes, and elements gets a numerical identity. If these numbers are in sequence, it can be lot more easier to find the members faster result interpretation can be done. Speed of work can be increased if we know that the elements are numbered in sequential order. Here is a way to do so : For numbering columns as shown below.
Select all columns of structure.Go to geometry → renumber → members.Press yes to the window that asks for confirmation.Give first number from where you want to start your numbering of Columns.Select available sort criteria in following sequence z coordinatex coordinatey coordinateClick Accept. You have done it. If you want numbers in vertical sequence interchange x and z coordinate.

### How to renumber Nodes in STAAD.Pro?

When we model the structure, the nodes, and elements gets a numerical identity. If these numbers are in sequence, it can be lot easier to find the members faster result interpretation can be done. Speed of work can be increased if we know that the elements are numbered in sequential order.
Here is a way to do so :
For numbering nodes floor wise as shown below.
Select all nodes of structure.Go to geometry → renumber → node.Press yes to the window that asks for confirmation.Give first number from where you want to start your numbering of nodes.Select available sort criteria in following sequence. Y co-ordinate Z co-ordinate X co-ordinateClick Accept. You have done it. If you want numbers in vertical sequence interchange x and z coordinate.Enjoy STAAD.ProRead: How to renumber beams in STAAD.Pro?

### How to hide error values from a cell in MS Excel?

Let's say your spreadsheet formulas have errors that you anticipate and don't need to correct, but you want to improve the display of your results. There are several ways to hide error values and error indicators in cells.
There are many reasons why formulas can return errors. For example, division by 0 is not allowed, and if you enter the formula =1/0, it returns #DIV/0. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. There are many ways to hide such values. Here are some methods to do the same.
Option 1:  Format text in cells that contain errors so that they don't show. Follow the seteps shown below. 1. Select the cells that contain the error value.
2. On the Format menu, click Conditional Formatting.
3. In the box on the left, click "Formula Is".
4. In the box on the right, type =ISERROR("reference"), where "reference" is a reference to the cell that contains the error value.
5. Click "Format", and th…

### how to hide 0 values in a spreadsheet?

option 1:
Perhaps the simplest way to hide all zero values in a sheet is to let the worksheet do it Just remember, this setting works at the sheet level. You must set it for each sheet in the workbook, as follows.

Click the File menu and then choose Options (under Help). In Excel 2007, click the Office button and then click Excel Options. In Excel 2003, choose Options from the Tools menu.Choose Advanced in the left pane. In Excel 2003, click the View tab.In the Display Options For This Worksheet section, uncheck the Show A Zero In Cells That Have Zero Value.Click OK.
option 2 :
The sheet setting will hide all zero values in the sheet. If you want to hide specific zero values, but not all, you can use a numeric format instead:

Select the cells that contain the zero values that you want to hide. Click the Home tab and click the Number group's dialog launcher (the small arrow in the bottom-right corner. In Excel 2003, choose Cells from the Format menu.Click the Number tab (if necessary…

### How to add title on every page in MS excel?

Many a times we have lots of rows of data. When we want to print the same we need titles to be appeared on every page. There is an option for it in excel.