Excel Data Group Button Left Code In The

In the same folder where I have saved this excel file, are lying photographs of individuals.

Is there a way to get this button located at the top row of the group.

The problem is, when I group 1-10 and then group 11-20 seperately, excel automatically makes 1-20 a single group and removes the individual groups that I wanted.

Excel Data Group Button Left Code In The

The sheetworkbook are not protected, nor shared, there is no VBA code in the file.

Does anyone knows what else can it be Everything else is working fine thanks.

For Ex:- If there are three Items.

A B C and forming a group of 2 then the the total no of combinations would be permut(3,1) 6.

I need this to be shown as follows depending on the no of itmes and no of group no2 in this case.

Ive tried to use Task Manager to stop the application, but as soon as open up Excel it goes right back to opening the spreadsheets and starts calculating again.

I have spreadsheets saved, so dont have to recover.

Dean.

Its an existing file so I dont know what restrictions were placed on the workbook.

When you highlight the section to copy and then go to the new workbook both the paste and paste special are grayed out.

This is true whether you right-click the mouse, go to the edit menu, or use control keys.

This occurs with any data type and the most simple workbooks.

I have seen some suggestions here but none have worked for this particular problem.

I have reset the menus and renamed the.xlb files and neither helps.

You can open the clipboard and the paste will work, but there is no paste special option.

A1.

These values can range anywhere from -100,000,000 to 10,000,000.

Id like to be able to sort them into the following buckets:-.

Right now Im recreating the table in Word, then pasting, which doesnt loose formatting.

A specific problem is cells which dont have borders show up with very light grey borders in Outlook.

The days of the week consists of Name Date Hours The 8th sheet consists of Name, Days of the week in their own column (7 columns in total), Total Hours and Total Days Worked Now.

So when the end of the week is done I have all the Employees weekly hours and days worked all finished.

This file is to track about 100 employees that are on a rotational work schedule.

The last column is for hyperlinking photographs of individuals.

Excel For Mac Data Group Button Left