مشکل اضافه کردن سطر در اکسل

[milad@farafan]

سلام خدمت همه دوستان
یک فایل اکسل دارم میخوام یک سطر بهش اضافه کنم با پیغام زیر مواجه میشم، لطفا کمک کنید

[hamedrezaee]

دوستان عزیز منم مشکل مشابه دارم. نمیتونم سطر اضافه کنم. البته مال من خطا نمیده. فقط اضافه نمی کنه. مشکل کجاستتتت؟؟

[امين اسماعيلي]

This issue may occur if a formula has been added to the entire worksheet, or if formatting (such as a border) has been added to an entire column or row

mige in moshkel momkene zamani etefagh biofte agar shoma ye formoli ya ye formatio vase kole ye soton ya radife emal karde bashi.in moshkel pish miad


ama rahe hal

To resolve this issue, clear each of the cells in the row or column, and  then remove any formatting from the remaining rows and columns. To do  this, follow these steps:  [LIST][*]Click the heading cell in the first blank  column to the right of your data. (The heading cell is the first cell  in each column, and indicates which column you are in). [*]Press  and hold down CTRL+SHIFT, and then press the RIGHT ARROW key to select  all of the columns to the right of the first column that you clicked. [*]On the Edit menu, click Delete. [*]Click the first blank row below the last row in your data. [*]Press  and hold down CTRL+SHIFT, and then press the DOWN ARROW key to select  all of the rows below the first row that you clicked. [*]On the Edit menu, click Delete.

Note To remove any formatting from the remaining cells, continue to follow these steps. [*]Click the small cell between the first row heading and the first column heading to select the entire worksheet. [*]On the Format menu, click Cells, and then click the Border tab.

Note The formatting added to the remaining cells may vary. Step 8 assumes that you want to remove border formatting. To remove other types of formatting, you may need to change settings under another tab in the Format Cells dialog box. [*]Click None, and then click OK. [*]Click any cell in the row where you want to insert a row. [*]On the Insert menu, click Row. To insert a column click Column. [/LIST]