atrium(noun) any chamber that is connected to other chambers or passageways (especially one of the two upper chambers of the heart) atrium(noun) the central area in a building; open to the sky.
Use the ' Paste Special Transpose ' option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.o transpose data, execute the following steps. 1. Select the range A1:C1. 2. Right click, and then click Copy. 3. Select cell E2. 4. Right click, and then click Paste Special... 5. Check Transpose.
From this morning's mailbag:I want to add years to a given date. For instance I want to add 5 years to 16th Nov.2001. How can I do that?There are a lot of cool functions for dealing with dates in Excel.One of the most versatile functions is the =DATE() function.It accepts three arguments, Year, Month, and Day.e has a column of dates in column A. Each date is the first of the month. Bob would like a formula that would extend the series. You can change the formula to:=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))In Bob's case, you would not need a formula.