How to Make Excel File Like This

[maamiradina]

I have a file And I want to make like this But I am Idiot To Excel And Completely New to Excel
I am using Excel 2013
Please make a video for me to make this file like this
Please See The Attachment
Apr-15 Fee Details.xls

[alansidman]

Since you already have the file, I am not sure exactly what you are looking to do. Just copy and paste to a new file if you need another copy. If this is not what you are after, then please clarify in simple terms what you want. Your current request is to vague to warrant a detailed response.

[maamiradina]

And also I am new to Excel And not understand anything yet. because of that I want to learn from This forum Many thing that will work for me

[maamiradina]

Yes it is original and working also
But this is not made by me
This is made by another person who gave me
But I want to make like this.
Because I am not understand that how he made this, And he is not saying to me that how he made this?
Please make a video while making this file
Thanks for your kind reply

[RedSummer]

I would also like to know how they make the vertical borders in Row 3 tilt.
Screen Shot 2015-04-05 at 1.37.36 AM.png
At first I thought they were simply diagonal but upon formatting I could see that they were in fact the Left and Right borders. I have no idea how to do this.

[alansidman]

This forum is here to help with specific issues. Its function is not to be a full scale tutorial site. If you are looking to learn Excel, then I urge you to look on the internet for Excel tutorials. There are numerous sites available for that. If you have specific questions about the file, then we will be happy to address those issues.

[Subverter]

RedSummer


1- Select any cell and apply "All Borders" effect
2- Go to "Format Cells" window and click "Alignment" tab.
3- Under the "Orientation" at the right .. Write (70) degrees.

That's all

[newdoverman]

A modification to the fine directions given by Subverter to give you a little more control of the borders:

The directions are the same except for the borders:

Select the cells, right click, select Format Cells,
Click on the Alignment Tab,
Select the angle that you want for the text.
Click on the Borders Tab, select the line style and colour and apply to the example box in the dialogue box and click ok.

[maamiradina]

I want to only know that how he Add these formulas Automatically into the all file in sequence. Pls Refer to the attached files

And how the cells are erased in picture No 2 .

[newdoverman]

The formulae are entered into the top cell of each column which is row 4.

The first formula is =F4. This is entered into the top cell as shown in your image then after entering, the cell is selected (clicked on) and the little square in the lower right of the selected cell is grabbed by the mouse cursor (left button held down) and then the cursor is dragged down the column. This will fill each cell with the formula being incremented to be correct for the cell that it is in because of the RELATIVE references of the formula (no $ in front of the column letter or row number).

Another way of filling the formula down the column is to enter the formula in the top cell as above then click on that cell to select it and while holding down the left button drag the mouse down as far as required to select all the cells that you want the formula in. Then with the cells selected, hold down the Ctrl key and hit the D. This will fill the selection with the formula.

Repeat for all the columns with formulae.

[RedSummer]

I'm just finding that only the text is changing alignment while the borders stay the same.

[newdoverman]

I thought that I answered the question about the formulae in the first image but the second image makes no sense to me at all.
Please post a workbook and not an image. No one can work with images.

[maamiradina]

I already uploaded the whole file
and in the second image how the cells are erased and the area is become empty

[newdoverman]

If you are wondering how the data is filled in on the Reminder worksheet, (presumably to print a notice) it was either done manually one at a time or there was a macro, that is no longer present, that would fill in the number in the upper right corner.